# Help to find Total Hours to complete TAT

#### jawaharprm

##### New Member
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

• 9 KB Views: 6

#### Logit

##### Active Member
Paste in C2 and copy down column :

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

#### 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 """)

#### pecoflyer

##### Active Member
Whats is TAT please?

#### 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

#### vletm

##### Excel Ninja
jawaharprm
Did You take care of custom format `[h]:mm` ?
... then it show like 70:41.

#### p45cal

##### Well-Known Member
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"
My suggestions do NOT show that…

#### jawaharprm

##### New Member
jawaharprm
Did You take care of custom format `[h]:mm` ?
... then it show like 70:41.
Thanks You sir,

it works...