| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating total elapsed minutes between two dates
Try this:
=(date2-date1)*1440 A1 = 6/16/09 10:15 PM A2 = 6/17/09 3:45 AM =(A2-A1)*1440 Format as General -- Biff Microsoft Excel MVP "Doug in Freight" <Doug in wrote in message ... I'm interested in calculating a production rate as a function of time and need help with determining total minutes between two dates. Date 1 would be 6/16/09 10:15 PM Date 2 would be 6/17/09 3:45 AM Can someone help with a formula that would return the total elapsed minutes of 330? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Need to determine the elapsed Minutes between 2 dates in excel | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| Calculating Total Number of Minutes in a Clock Setting | Excel Discussion (Misc queries) | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
Threaded Mode
