Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
On Time Calculation
I have two columns, one is Sched Dely Date/Time (O5) and the other is Actual
Dely Date/Time (N5). If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and the Actual Dely Date / Time is 04-Mar-10 12:52 PM, the delivery would be on time. But if I use the IF function of O5N5 it give me a TRUE answer when in fact it is FALSE. What would be the correct formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Time calculation | Excel Worksheet Functions | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |