Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I get the total hrs of a delay when it is greater than 24
I work for an airline and sometimes I need to know the total hours of a
delay, and when the delay is greater than 24 hours. In my report I hav something like this: arrival time in colum A departure time colum B result in colum C 10/23/09 21:00 10/24/09 23:00 2:00 and really the delay was of 26 hours. How can I obtain this? I already set up my Tools-Options-Canculation to 1904 date system |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I get the total hrs of a delay when it is greater than 24
Format Custom as [h]:mm
No need to use 1904 date system -- Kind regards, Niek Otten Microsoft MVP - Excel "El Ixmahana" wrote in message ... I work for an airline and sometimes I need to know the total hours of a delay, and when the delay is greater than 24 hours. In my report I hav something like this: arrival time in colum A departure time colum B result in colum C 10/23/09 21:00 10/24/09 23:00 2:00 and really the delay was of 26 hours. How can I obtain this? I already set up my Tools-Options-Canculation to 1904 date system |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I get the total hrs of a delay when it is greater than 24
Custom Format to [h] to see 26
Gord Dibben MS Excel MVP On Mon, 26 Oct 2009 12:33:02 -0700, El Ixmahana wrote: I work for an airline and sometimes I need to know the total hours of a delay, and when the delay is greater than 24 hours. In my report I hav something like this: arrival time in colum A departure time colum B result in colum C 10/23/09 21:00 10/24/09 23:00 2:00 and really the delay was of 26 hours. How can I obtain this? I already set up my Tools-Options-Canculation to 1904 date system |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delay in formula | Excel Discussion (Misc queries) | |||
Greater than less than total in a column | Excel Discussion (Misc queries) | |||
delay in entry etc.... | Excel Discussion (Misc queries) | |||
Calculation Delay | Excel Discussion (Misc queries) | |||
Print Delay | Excel Discussion (Misc queries) |