What is the formula to calculate electricity consumption

[TSK]

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)

 

[Mike H]

Try this in a3

=(A1*24)*A2

Mike

 

[David Biddulph]

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.

 

[Mike H]

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/com...feed&cid=3bf2f736-4c6b-41f5-9970-676bf991bfc5

Mike

 

[David Biddulph]

I didn't say it was a duplicate.

The other message where we'd discussed the relationship betwen Excel time
and hours was: