Using Numbers 3.6.2, I am using cells formatted as "Duration" in days. I then have a SUM cell that sums all the durations and shows for example "64d" (Suppose in cell D1). I then do in a new cell (D2 for example) the following formula: =D1 and change the display days to hours. It shows "1536h".

But I want to use days of 8h (a normal average working day). How can I do this?

If I change the formula to =D1*8, then I get 8 times as many days which is certainly not what I want.

1 Answer 1


Changing the formula to =D1/24*8 does the trick.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .