Calculating Hourly Rate of Temperature Change in Excel (2003)

I've been tracking internal and external temperatures for a greenhouse I've constructed.  I would like to compare the rate of decline in interior temperature (at an hourly rate) comparing it to the rate of decline outside.  I'm having trouble converting the time fields to calculate number of minutes elapsed between observations.  Attached is a sample of the data showing date, hour of day, and observed tempterature settings.  Your help would be appreciated with the conversion.  I can get the hourly rate once that's figured out.  Thanks!
Who is Participating?
barry houdiniConnect With a Mentor Commented:
So you probably want the time difference as a decimal number of hours. To get that try this formula in Row 4 to get the difference between row 3 and row 4


format as a number

That should give you 0.833 (representing 50 minutes as a decimal)

regards, barry
Christian de BellefeuilleConnect With a Mentor ProgrammerCommented:
can't you just use =MINUTE(C4-C3) in a cell to calculate the number of minutes?
Christian de BellefeuilleConnect With a Mentor ProgrammerCommented:
whoops, i forgot the date column.  Then use a mix of our solutions:

mcnAuthor Commented:
Thank you both for the quick replies!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.