On Thu, 17 Aug 2006 07:16:03 -0700, ditorejax
<ditorejax@discussions.microsoft.com> wrote:

>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?

One way which results in hours and decimal of an hour is

=IF((end-start)<0,(end-start)*24+24,(end-start)*24)

If you want to see hours and minutes you'd need to modify it to pick
up the decimal fraction and multiply it by 60.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________