Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time calculating problem
I need to calculate column C but am having trouble due to the date
reference in column B. The data in column A is static and user defined. The data in column B is taken from an Access db and changes each day. A B C Expected Arrival Time Actual Arrival Time Minutes Early/Late 2:30:00 AM 7/24/2006 2:08:31 AM 2:00:00 AM 7/24/2006 2:33:23 AM 2:00:00 AM 7/24/2006 2:19:09 AM 2:15:00 AM 7/24/2006 12:36:12 AM 12:45:00 AM 7/23/2006 11:52:39 PM 12:45:00 AM 7/23/2006 11:45:39 PM Any and all help is GREATLY appreciated. Perry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time and pay in excel | Excel Discussion (Misc queries) | |||
Calculating Time | Excel Discussion (Misc queries) | |||
Time calculation problem (URGENTProject due) | Excel Discussion (Misc queries) | |||
problem in date time picker size | Excel Discussion (Misc queries) | |||
1/0/1900 10:18:48 AM Time problem | Excel Worksheet Functions |