Converting a calculated duration in Numbers from days to hours

I have a spreadsheet in Numbers that calculates hours worked each day from start and end times. Previously I have used a Sum formula to then get the total worked for the month.

Historically I had it presenting this total in hours but when I have gone to create a sheet for a new year it will only present the result in days and hours. In formatting it just shows as automatic. I can’t see what I did/selected previously to change this. Can anyone help?

iPad Pro, iOS 12

Posted on Mar 4, 2019 3:50 AM

Top-ranking reply

jaxjason

Level 5

5,063 points

Posted on Mar 8, 2019 9:42 AM

When you say it says automatic, are you talking the first format menu, or after you click through to the duration settings using the little circled i button?

If it is inside the duration settings, just de-select the automatic units slider button thing and you should be able to choose just the hours again.

If it is saying Autoimatic on the first format menu, then you need to select Duration (I had to select the whole column, not just the cells) and then select duration as the data type.

Jason

View in context

Converting a calculated duration in Numbers from days to hours

Similar questions