What is the formula to calculate electricity consumption

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TSK - 05 May 2008 12:51 GMT

Time required - 1:30 (Cell A)

Assuming 1.5KwH (Cell B)

Cell A1 - 1:30 (Time format)

Cell A2 - 1.5Kwh (Number format)

Cell A3 - A1*A2 (I need the answer to be 2.25KwH)

Reply to this Message

Mike H - 05 May 2008 13:22 GMT

Try this in a3

=(A1*24)*A2

Mike

> Time required - 1:30 (Cell A)
>
[quoted text clipped - 5 lines]
>
> Cell A3 - A1*A2 (I need the answer to be 2.25KwH)

Reply to this Message

David Biddulph - 05 May 2008 13:24 GMT

You've been told in another thread that Excel times are in whole days, and
hence you what the conversion is between Excel times and hours.

Signature

David Biddulph

> Time required - 1:30 (Cell A)
>
[quoted text clipped - 5 lines]
>
> Cell A3 - A1*A2 (I need the answer to be 2.25KwH)

Reply to this Message

Mike H - 05 May 2008 13:35 GMT

David,

I share your irritation concerning multiple posts but in this case the only
similar one I can see is this unanswered one from yesterday. Where is the
duplicate?

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.excel.misc&mid=7c65c23d-5453-457e-982a-281cabf5feed&cid=3bf2f736-4c6b-41f5-9970
-676bf991bfc5

Mike

> You've been told in another thread that Excel times are in whole days, and
> hence you what the conversion is between Excel times and hours.
[quoted text clipped - 7 lines]
> >
> > Cell A3 - A1*A2 (I need the answer to be 2.25KwH)

Reply to this Message

David Biddulph - 06 May 2008 13:40 GMT

I didn't say it was a duplicate.

The other message where we'd discussed the relationship betwen Excel time
and hours was:
news:FaadnV4RGPntdYPVnZ2dnUVZ8vydnZ2d@bt.com
--
David Biddulph

> David,
>
[quoted text clipped - 19 lines]
>> >
>> > Cell A3 - A1*A2 (I need the answer to be 2.25KwH)

Reply to this Message