Time difference across midnight PT 2
On Wed, 19 May 2010 10:16:04 -0700, Norm
wrote:
You probably want something like:
=Est-Actual+(Est<Actual)
--ron
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!!
Please don't split your thread. See my response in your original thread.
--ron
|