minutes calculation formula

[ferde]

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

 

[T. Valko]

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 are: 15, 360, 1020

 

[ferde]

Thank you so much for the response.... it works like a charm!!!

 

[T. Valko]

You're welcome. Thanks for the feedback!