mcn

asked on

# 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

MCN-TempTracker.xls

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER