| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference across midnight | Excel Discussion (Misc queries) | |||
| Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
| Time after midnight | Excel Worksheet Functions | |||
| formula to calculate time difference crossing midnight | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Linear Mode
