Duration calc between two timestamps

Calculating time difference with the TEXT function

• Calculate hours between two times: =TEXT(B2-A2, "h")
• Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm")
• Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")