Posted to microsoft.public.excel.worksheet.functions
|
|
Converting hours, minutes, seconds, to hours
Try again. It does work!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"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?
|