Turn Around TimeWhats is TAT please?
Paste in C2 and copy down column :
Code:=TEXT(B2-A2,"h"" hrs ""m"" mins """)
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 """)
My suggestions do NOT show that…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"