Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating total elapsed minutes between two dates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating total elapsed minutes between two dates
something like:
=(A2-B2)*1440 Explaination: Excel treats days as integers, and time as decimals. Multiplying a date by 24 gives you hours, and then again by 60 gives you minutes. (24 * 60 = 1440) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Doug in Freight" wrote: 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? |
#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? |
Reply |
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 |