minutes calculation formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top