Time difference across midnight PT 2
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!! |
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 |
All times are GMT +1. The time now is 08:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com