Determining early and late arrival times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you use the TIME function in EXCEL when attempting to
calculate the difference between a scheduled delivery time
and the actual delivery time the cell format for time does
not like early arrivals or (-) negative numbers. Is there
a function that might allow me to do this?
 
You have to use either the 1904 date system under tools>options>calculation
or
decimal time. Else it will be displayed as ######. If it wouldn't be to
calculate with
you can use conditional formatting and red fonts

if A1 is the scheduled time and B1 the actual time

=ABS(B1-A1)

then select the cell, do format conditional formatting,
formula is and use

=A1>B1

click format and select a red font, click OK twice..
Decimal time would be

=(B1)*24-(A1)*24

formatted as general
 
Back
Top