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?

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?

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?