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