Converting Time in a number

S

Soccerboy83

I am currently trying to convert a difference in time, to a number so that i
can use it in a equation. What i want to do is subtract the times from each
other so that i get something like 12:45 - 12:20 = 25 mins so that i can
take 150 MJ/min x 25 mins to get 3750 MJ. However every time i do this my
answer gets a date value, so then i format my cell to be a number not a time
it gives me 0 as a result. Can you please help. Below is what i am looking
for.
What i have is this
Date Time Average Energy Used Total Energy Used
1/1/09 12:00 - MJ/min
1/1/09 12:10 124 MJ/min
1/1/09 12:20 125 MJ/min
1/1/09 12:45 150 MJ/min
 
E

Eduardo

Hi,
multiply the difference by the number of minutes in a day, (1440) and
format the result as a number
 

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

Similar Threads

max and min help. 5
calculating sum and average values for specific days only 2
Excel calcutions using date/timestamps 1
Finding date and time for max and min values 2
Pls help for Simple Calculation 1
Displaying time gaps 6
Count entries in the column translating to minutes. 5
vlookup or Match 6

Top