Remember Me?

#1
April 2nd 07, 04:44 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 709
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
April 2nd 07, 04:52 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 10,593
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
April 2nd 07, 05:42 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jonathan Bickett Excel Worksheet Functions 5 March 7th 07 05:22 PM John Excel Discussion (Misc queries) 1 November 13th 06 05:49 PM Annabelle Excel Discussion (Misc queries) 3 February 21st 06 01:34 PM klwinston Excel Worksheet Functions 3 January 24th 06 01:18 AM marie Excel Worksheet Functions 7 December 7th 05 02:36 PM

All times are GMT +1. The time now is 07:13 AM.