Why won't the format 'duration' stick when a cell is formatted?
I have a table with a column consisting of durations, like 0:38:09, formatted as duration throughout. Now I want to sum the column. The result doesn't look like a sum of all my durations, and when I look at the format, it shows 'date and time'. So I change the format of the summing cell to 'duration'. This appears to be allowed, but the moment I press 'return', the format reverts to 'date and time' and I just can't see the sum.
I see from earlier posts that if I reformat my data cells to be more like 0h38m09s, then it might work 0 haven't tried it yet, but what's wrong with my originally formatted cells? I have checked them all and they are all really set to 'duration'. Is this a bug in Numbers?
iMac Line (2012 and Later)