Calculating total elapsed minutes between two dates

D

Doug in Freight

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?
 
L

Luke M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top