• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help to find Total Hours to complete TAT

p45cal

Well-Known Member
I would have in C2:
=B2-A2
format the cell with custom format:
[h]:mm
or to be like Logit's:
[h] "hrs" m "mins"
then copy the cell down.
By doing it this way, you can still carry out arithmetic on the results in those cells.

This gives different results for rows 5 and 6. To show the hours correctly Logit's formula would be:
=TEXT(B2-A2,"[h]"" hrs ""m"" mins """)
 

jawaharprm

New Member
Paste in C2 and copy down column :

Code:
=TEXT(B2-A2,"h"" hrs ""m"" mins """)
Hi Sir,

Thanks for your Time, its working file but there is date started with "7/30/2021 9:49:13 AM" and end with "8/2/2021 2:40:06 PM" it is aroung 3 days with while using formula it calculate as "4 hrs 50mins" its is any way to change. Pls help..

Thanks
Jawahar
 

jawaharprm

New Member
I would have in C2:
=B2-A2
format the cell with custom format:
[h]:mm
or to be like Logit's:
[h] "hrs" m "mins"
then copy the cell down.
By doing it this way, you can still carry out arithmetic on the results in those cells.

This gives different results for rows 5 and 6. To show the hours correctly Logit's formula would be:
=TEXT(B2-A2,"[h]"" hrs ""m"" mins """)

Hi Sir,

Thanks for your Time, its working file but there is date started with "7/30/2021 9:49:13 AM" and end with "8/2/2021 2:40:06 PM" it is aroung 3 days with while using formula it calculate as "4 hrs 50mins" its is any way to change. Pls help..

Thanks
Jawahar
 
Top