• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

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!
MCN-TempTracker.xls
0
mcn
Asked:
mcn
  • 2
3 Solutions
 
Christian de BellefeuilleProgrammerCommented:
can't you just use =MINUTE(C4-C3) in a cell to calculate the number of minutes?
0
 
barry houdiniCommented:
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

=(B4+C4-B3-C3)*24

format as a number

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

regards, barry
0
 
Christian de BellefeuilleProgrammerCommented:
whoops, i forgot the date column.  Then use a mix of our solutions:

=MINUTE(B4+C4-B3-C3)
0
 
mcnAuthor Commented:
Thank you both for the quick replies!
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now