Home |
Search |
Today's Posts |
#1
|
|||
|
|||
minutes between
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
Adding minutes to time | Excel Discussion (Misc queries) | |||
Minutes | Excel Worksheet Functions | |||
convert minutes into hours:minutes | Excel Worksheet Functions |