Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 847
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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