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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
On time arrival Richard Excel Discussion (Misc queries) 2 April 2nd 07 05:42 PM
Modelling arrival intervals using Poisson distributions John Excel Discussion (Misc queries) 1 November 13th 06 05:49 PM
Display latest arrival date Annabelle Excel Discussion (Misc queries) 3 February 21st 06 01:34 PM
Function needed to calculate arrival patterns klwinston Excel Worksheet Functions 3 January 24th 06 01:18 AM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017