minutes calculation formula
 

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

minutes calculation formula
 

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

minutes calculation formula
 

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

"T. Valko" wrote:

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

minutes calculation formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"ferde" wrote in message
...
Thank you so much for the response.... it works like a charm!!!

"T. Valko" wrote:

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