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