Hours & Minutes to Hourswith Decimal

October 17, 2011 at 11:58:59
Specs: Windows 7
Hi guys,
I have a solution to a large timesheet calculation formatted as [h]:mm Is there any way to format this as strictly hours? i.e. if the solution results in 29:10 (twenty-nine hours and ten minutes) is there any way to format the solution to show 29.17 hours?

See More: Hours & Minutes to Hourswith Decimal

Report •


#1
October 17, 2011 at 12:25:02
With 29:10 in A1, try this:

Format another cell as Number and use =A1*24

If that doesn't work we'll need some more infomation about the cell that contains 29:10, such as the formula used to get that value and the underlying data that was evaluated.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question