Question Locked

Help: Excel Formula for Kilowatt Hours (kWh)

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by Member 25348569

for our Carbon Reduction, to make the world safe for butterflies and baby voles...

In E10

=D8*24*365.25/1000 gives you kWh/year
=D8*24*30.5/1000 gives you kWh/month using your definition of a month
=D8*24/1000 gives you kWh/day

If you want to wizz them,
=E10*0.54055/1000 for CO2 tons per annum with E10 containing kWh pa

This discussion is closed to new replies.