# 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

• 1

#### by which software I can make my PD portable?

webtechexprt ·

• 8

#### what is the best chatbot software for small business?

nathanlohey ·

• 2

Buchiiii ·

• 2

#### Which open-source time tracking software is the best?

riedelrichard21 ·

• 2

#### Best email marketing software

aswanthsingampalli ·