=(A2A3)+A3-A2

1 only needs to be added if A2A3 otherwise you get 24 extra hours when
times don't go over midnight. You will see the problem when you start
summing the times and if you format as [h]:mm:ss

"Marcelo" wrote:

Hi,

one way is add 1 in 00:15:00

assuming that 23:50:00 is on A2 and 00:15:00 is on A3
=a3+1-a2

=00:25:00

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"ditorejax" escreveu:

In Excel I have been trying to find an easier way to calculate a time
difference where the times cross midnight. Example:
Start time: 23:50:00
End time: 00:15:00

How would you formulate an equation to determine the duration of time or
differnce between the start and end time?