Posted to microsoft.public.excel.misc

Norm

external usenet poster

Posts: 71

Time difference across midnight

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!!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro / function text time to 24hr excel time passed midnight fortotaling hr's	Russmaz	Excel Worksheet Functions	2	March 6th 09 04:58 AM
Time after midnight	Steved	Excel Worksheet Functions	2	May 30th 07 08:10 PM
time around midnight	Mai-Britt	Excel Worksheet Functions	2	May 9th 07 01:05 PM
formula to calculate time difference crossing midnight	ditorejax	Excel Worksheet Functions	3	August 17th 06 04:46 PM
Calculating time difference over midnight!	sygazelle	Excel Discussion (Misc queries)	4	September 29th 05 04:59 PM

All times are GMT +1. The time now is 11:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us