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?