| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hours & minutes calculation | Excel Discussion (Misc queries) | |||
| calculation with minutes | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
| Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
Linear Mode
