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)