# Software

## Question

Locked

### Help: Excel Formula for Kilowatt Hours (kWh)

By ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

### I had to do a whole bunch of this

by 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

• 13

#### Suggest a company that provides services for an e-commerce website

jsjohnsmith1986 ·

• 4

#### Best free VPN forWindows?

davidward8668 ·

• 3

#### What is the best of best software for business software for sole traders?

CreightonWilliamBrow ·

• 0