View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ary Ary is offline
external usenet poster
 
Posts: 2
Default Converting hours over 24 into decimal format

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