Try firstly reading again what your screen is telling you, and secondly
reading again what you were told to do.

You tell us that you got the value 15.36, but if you look again I think
you'll find it is saying 15:36, not 15.36 (unless for some unknown reason
you decided to custom format the cell as hh.mm with a full stop instead of
the customary colon in the time format). [If you want to understand why
it's saying 15:36, try temporarily reformatting as [h]:mm, and then
calculate for yourself what 24 times your original 129:39 is.]

Roger told you:
"Format the cell with the formula as General or Number
FormatCellsNumberGeneral"
.... but how have *you* formatted the cell with the formula?

Read Roger's post again. Do as he said. Then see what answer you get.
--
David Biddulph

"chouck" wrote in message
...
when I tried =A1*24 (129:39:00*24) I got the value 15.36. What I want to
get
is the value 129 or 130 if there is a formula that rounds up.


"Roger Govier" wrote:

Hi

If you mean how do you convert it to decimal hours, then multiply by 24
as
Excel stores hours as fractions of a day (24 hours)
With value in A1
=A1*24 result 129.55
Format the cell with the formula as General or Number
FormatCellsNumberGeneral

If you are saying you want it to display as 5 days 9 hours 33 minutes
then
FormatCellsNumberCustomd:hh:mm:ss
5:09:33:00
--

Regards
Roger Govier

"chouck" wrote in message
...
How do you vonvert hours, minutes, seconds (129:39:00) to hours?