What is the formula to calculate electricity consumption
 

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)

What is the formula to calculate electricity consumption
 

Try this in a3

=(A1*24)*A2

Mike

"TSK" wrote:

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)

What is the formula to calculate electricity consumption
 

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.
--
David Biddulph

"TSK" wrote in message
...
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)

What is the formula to calculate electricity consumption
 

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/comm...0-676bf991bfc5

Mike
"David Biddulph" wrote:

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.
--
David Biddulph

"TSK" wrote in message
...
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)

What is the formula to calculate electricity consumption
 

I didn't say it was a duplicate.

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

--
David Biddulph

"Mike H" wrote in message
...
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/comm...0-676bf991bfc5

Mike
"David Biddulph" wrote:

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.
--
David Biddulph

"TSK" wrote in message
...
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)