Start in A1 end in B1

if the dates are included just do


=B1-A1

then format result as [hh]:mm:ss

if less than 24 hours but start time later than end times, e.g. start time
08:00 PM and end time 06:00 AM


=B1-A1+(A1B1)

or

=MOD(B1-A1,1)

format as time


--


Regards,


Peo Sjoblom




"wahoos" wrote in message
...
I'm trying to find the difference between start time and end time when the
total time will exceed a 24 hour period.

10:00 PM Friday 3:00 AM Sun