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?

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.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History