[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

"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)

[David Biddulph[_2_]]

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)

[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/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)

[David Biddulph[_2_]]

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)