• 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

Hi Team,

Please Help to find Total Hours to complete TAT from Begin date - End date

Sample file enclosed for your reference.


Thanks
Jawahar R
 

Attachments

  • to find hours.xlsx
    9 KB · Views: 7
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 """)
 
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
 
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
 
Back
Top