Hi All

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

Example...... scheduled arrival...........actual
arrival...........Difference
----------------------22:00----------------------22:30-------------30mins
----------------------22:00----------------------00:30-------------150
mins
-----------------------22:00---------------------21:30...............-30
mins
............................00:30................. .........23:30...............
- 60 mins
.............................00:30................ .........00:15..................-15
mins


I know the schedule before hand so on a daily basis all I need to enter
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 the
first wagons arrive around 20:00 and the last ones in arrive around
02:00 the following morning but all I need is the difference between
scheduled arrival and actual arrival.

Kind regards Mick
PS feel free to email your excel files to I use
this as a email address I give the world


--
pogo827
------------------------------------------------------------------------
pogo827's Profile: http://www.excelforum.com/member.php...o&userid=24108
View this thread: http://www.excelforum.com/showthread...hreadid=377141

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

In article ,
pogo827 wrote:

Hi All

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

Example...... scheduled arrival...........actual
arrival...........Difference
----------------------22:00----------------------22:30-------------30mins
----------------------22:00----------------------00:30-------------150
mins
-----------------------22:00---------------------21:30...............-30
mins
...........................00:30.................. ........23:30...............
- 60 mins
............................00:30................. ........00:15...............
...-15
mins


I know the schedule before hand so on a daily basis all I need to enter
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 the
first wagons arrive around 20:00 and the last ones in arrive around
02:00 the following morning but all I need is the difference between
scheduled arrival and actual arrival.

Kind regards Mick
PS feel free to email your excel files to I use
this as a email address I give the world

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")


--
pogo827
------------------------------------------------------------------------
pogo827's Profile: http://www.excelforum.com/member.php...o&userid=24108
View this thread: http://www.excelforum.com/showthread...hreadid=377141

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.

In article ,
pogo827 wrote:

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")

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


--
pogo827
------------------------------------------------------------------------
pogo827's Profile: http://www.excelforum.com/member.php...o&userid=24108
View this thread: http://www.excelforum.com/showthread...hreadid=377141