You need to format the cell as general

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"SAR" wrote in message
...

I must not be doing something right to get 2.25 hours.

I added times of day and got 2:15 (time value format-2hours & 15
minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,"day","hr")
with Number and General format and received #NAME?. Tried =A1*24 with
Number and General format and received 0.

Please help.


--
SAR
------------------------------------------------------------------------
SAR's Profile:
http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=539381