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?