The general formula for time difference when the time might span past
midnight is:

=MOD(End-Start,1)

Or

=End-Start+(End<Start)

--
Biff
Microsoft Excel MVP


"Norm" wrote in message
...
I have read all the other threads on this subject and they work fine for me
untill I need to cross midnight and the value is the time subtracted from
24
here are the cells:
Date Store Actual Arrival Time Est Arrival Time Variance
4/6/2010 33369 11:26:00 PM 12:27:00 AM -22:59
Can someone let me know what I have missed?
Cheers!!!