Question

Give an example of subtracting two time values, using Excel

formula.
formula.
​

Answer 1

Answer:

Formula 2. 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")