Converting hours over 24 into decimal format
I don't think I understand. When I do this, I get a completely different time:
A1 A2 =A1*24
126:47:59 19:11:36
I need it to read 126:47:59 and give me 126.7997
--
-Ary
"Pete_UK" wrote:
If you want them in decimal format then multiply by 24:
=A1*24
and format the cell as number with appropriate decimal places.
If you want to see them in time format, then click Format | Cells |
Custom and enter [hh]:mm:ss in the panel then click OK.
Hope this helps.
Pete
On Jul 4, 11:42 am, Ary wrote:
How would I convert hours such as 128:24:12 to 128.403?
In previous discussions, I saw someone suggest formatting the cell as
[hh]:mm, but I have no idea what this means nor how to do it.
--
-Ary
|