Need formula calculate difference between hours

Question

Need formula calculate difference between hours

Anonymous

What I have. What I need

A.          B.               D

1 11:45. 00:20. 12:35

10:24. 00:55. 14:30
10:45. 18:50. 8:05
10:01. 1:30. 15:29
15:33. 2:04. 10:31

Thanks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Ashish Mathur 102K Volunteer Moderator

Hi,

In cell C2, enter this formula and drag down

=B2-A2+(B2<A2)

Hope this helps.

0 comments

1 additional answer

Answer 1

riny 20,870 Volunteer Moderator

See picture below! Works for all calculations of end time minus start time.

0 comments

Share via

Need formula calculate difference between hours

1 additional answer