If the date changes at midnight you shouldn't have to worry about times
after midnight.

=ROUND(((C2+D2)-(A2+B2))*1440,0)

Format as GENERAL

Based on your sample the results a 15, 360, 1020

--
Biff
Microsoft Excel MVP


"ferde" wrote in message
...
A B C D
E
DateArriv TimeArriv DateDepart TimeDepart Total Minutes
8/8/2007 14:30 8/8/2007 14:45
8/9/2007 15:00 8/9/2007 21:00
8/10/2007 13:00 8/11/2007 6:00


Can anyone tell me the formula for calculating the total minutes for
column
E. When the dates changes past midnite....its tricky . Also I cant find a
format for just minutes for column E

Thank you
Deb