minutes between

[pogo827]

Hi All

I want to be able to work out minutes between schedule
arrival times and actual arrival times.

Example...... scheduled arrival...........actua
arrival...........Difference
----------------------22:00----------------------22:30-------------30mins
----------------------22:00----------------------00:30-------------15
mins
-----------------------22:00---------------------21:30...............-3
mins
............................00:30..........................23:30..............
- 60 mins
.............................00:30.........................00:15..................-1
mins


I know the schedule before hand so on a daily basis all I need to ente
is the actual this then should give me the difference.

Oh and yes just to make it fun for you it’s a night operation so th
first wagons arrive around 20:00 and the last ones in arrive aroun
02:00 the following morning but all I need is the difference betwee
scheduled arrival and actual arrival.

Kind regards Mick
PS feel free to email your excel files to (e-mail address removed) I us
this as a email address I give the worl

 

[JE McGimpsey]

If you don't expect differences of more than plus or minus 12 hours, try:

=TEXT((MOD(C1-B1+0.5,1)-0.5)*1440,"0 \min\s")

This assumes that actuals are in column C, scheduled in column B

 

[pogo827]

This does work in a older version of excel but in excel 2003 it
gives a #value, I thought that newer versions would be backward
compatible

=TEXT((MOD(C1-B1+0.5,1)-0.5)*1440,"0 \min\s")

 

[JE McGimpsey]

Hmmm... that's new to me, but then I don't use that technique very often.

Either change to

=TEXT((MOD(C1-B1+0.5,1)-0.5)*1440,"0 \mi\n\s")

or

=TEXT((MOD(C1-B1+0.5,1)-0.5)*1440,"0 ""mins"")

or

=(MOD(C1-B1+0.5,1)-0.5)*1440

and format the cell(s) with one of the above Custom Format codes.

 

[pogo827]

Thanks for that
I'm well impressed
all 3 worked fine :