Remember Me?

#1
April 2nd 07, 04:50 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 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

#2
April 2nd 07, 04:58 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,397
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

#3
April 2nd 07, 05:00 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
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

 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 Richard Excel Discussion (Misc queries) 2 April 2nd 07 05:42 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 05:51 AM.