Thread: On time arrival
View Single Post
  #2   Report Post  
Old April 2nd 07, 04:52 PM posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,593
Default On time arrival

One way




(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.