Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
On time arrival
A1: Scheduled arrival time.
B1: Actual arrival time. In C1, I would like to compute the time difference between scheduled and actual arrival time. I'm golden as long as the actual arrival is earlier than the scheduled time. When B1 is later than A1, I just get a result of #######. Is there a way for this time to be displayed as a negative? Any other suggestions for identifying late arrivals? Please no visual basic. I'm a rookie at this. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
On time arrival
One way
=IF(B1A1,B1-A1,TEXT(MOD(B1-A1,1),"-hh:mm")) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richard" wrote in message ... A1: Scheduled arrival time. B1: Actual arrival time. In C1, I would like to compute the time difference between scheduled and actual arrival time. I'm golden as long as the actual arrival is earlier than the scheduled time. When B1 is later than A1, I just get a result of #######. Is there a way for this time to be displayed as a negative? Any other suggestions for identifying late arrivals? Please no visual basic. I'm a rookie at this. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
On time arrival
But that would show -21:00 where the result of the calculation is -3:00.
Might I suggest changing Bob's formula to =IF(B1A1,B1-A1,TEXT(A1-B1,"-hh:mm")) -- David Biddulph "Bob Phillips" wrote in message ... One way =IF(B1A1,B1-A1,TEXT(MOD(B1-A1,1),"-hh:mm")) "Richard" wrote in message ... A1: Scheduled arrival time. B1: Actual arrival time. In C1, I would like to compute the time difference between scheduled and actual arrival time. I'm golden as long as the actual arrival is earlier than the scheduled time. When B1 is later than A1, I just get a result of #######. Is there a way for this time to be displayed as a negative? Any other suggestions for identifying late arrivals? Please no visual basic. I'm a rookie at this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
Modelling arrival intervals using Poisson distributions | Excel Discussion (Misc queries) | |||
Display latest arrival date | Excel Discussion (Misc queries) | |||
Function needed to calculate arrival patterns | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |