Help: Excel Formula for Kilowatt Hours (kWh)

By WebGuyBob ·
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


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



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I had to do a whole bunch of this

by neilb@uk In reply to Help: Excel Formula for K ...

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

Related Discussions

Related Forums