Time difference across midnight PT 2

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

You probably want something like:
=Est-Actual+(Est<Actual)

--ron
Click to expand...


Thanks Ron,
That helped but I have another problem when it is a negetive it goes back to
23:59

Date Store Actual Arrival Time Est Arrival Time Variance
4/15/2010 33035 8:00:00 PM 8:00:00 PM 0:00
4/15/2010 34287 8:46:00 PM 8:45:00 PM 23:59
4/15/2010 39210 9:28:00 PM 9:36:00 PM 0:08
Cheers!!
 
You probably want something like:


Thanks Ron,
That helped but I have another problem when it is a negetive it goes back to
23:59

Date Store Actual Arrival Time Est Arrival Time Variance
4/15/2010 33035 8:00:00 PM 8:00:00 PM 0:00
4/15/2010 34287 8:46:00 PM 8:45:00 PM 23:59
4/15/2010 39210 9:28:00 PM 9:36:00 PM 0:08
Cheers!!
Click to expand...

Please don't split your thread. See my response in your original thread.
--ron
 
Back
Top