Help: Excel Formula for Kilowatt Hours (kWh) - TechRepublic
Question
August 23, 2010 at 07:33 AM
webguybob

Help: Excel Formula for Kilowatt Hours (kWh)

by webguybob . Updated 15 years, 9 months ago

Hi, All!

How would one write an MS Excel formula for total Kilowatt Hours (kWh), given that:

* Total Wattage is known in cell D8
* Wattage is used 24 hours per day
* kWh to be displayed in cell E10

Based on the assumption that this is correct:

(Watt Usage * Hours/Day * Days/Mo.) / 1000 = Kilowatt Hours used that month

Example:

(60w * 24 hours/day * 30.5 days/Mo.) / 1000 = 43.92 kWh per month

TIA,

Bob

This discussion is locked

All Comments