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