On time arrival
 

A1: Scheduled Arrival Time
B1: Actual Arrival Time

In C1, I would like to compute the difference between scheduled and arrival
times so I can address or look into any major delays. So far, I'm golden as
long as B1<A1 because this is a positive number. However, I get a weird
result of ###### when B1A1 because it is technically a negative number.

Any ideas on how I can write a formula to compute these negative values? Any
other suggestions for identifying late arrivals? Your help is appreciated.
Please not visual basic since I am a rookie with Excel.

Thanks

On time arrival
 

try
= max(0,B1-A1)
this will keep negatives from happening

"Richard" wrote:

A1: Scheduled Arrival Time
B1: Actual Arrival Time

In C1, I would like to compute the difference between scheduled and arrival
times so I can address or look into any major delays. So far, I'm golden as
long as B1<A1 because this is a positive number. However, I get a weird
result of ###### when B1A1 because it is technically a negative number.

Any ideas on how I can write a formula to compute these negative values? Any
other suggestions for identifying late arrivals? Your help is appreciated.
Please not visual basic since I am a rookie with Excel.

Thanks

On time arrival
 

You could change to 1904 date system, but in that case beware if you are
trying to copy data to and fro between the two systems.
--
David Biddulph

"Richard" wrote in message
...
A1: Scheduled Arrival Time
B1: Actual Arrival Time

In C1, I would like to compute the difference between scheduled and
arrival
times so I can address or look into any major delays. So far, I'm golden
as
long as B1<A1 because this is a positive number. However, I get a weird
result of ###### when B1A1 because it is technically a negative number.

Any ideas on how I can write a formula to compute these negative values?
Any
other suggestions for identifying late arrivals? Your help is
appreciated.
Please not visual basic since I am a rookie with Excel.

Thanks