Converting hours over 24 into decimal format
Multiply time * 24
select your cell and then format:cells:custom and enter a format of [hh]:mm:ss
Enter your time in that cell 18:22:13 (say cell A1)
In b1 typr =A1*24
Change thje format to general and your done.
Mike
"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
|