Format changes from Duration to Automatic and I cannot change it back.
I am adding a quarterly summary table and drawing data from separate weekly tables. My data is formatted as Duration, but when I add the cells to the formula, the total cell changes formatting to Automatic. I have tried to change the formatting back to Duration but Numbers will not let me. Now my data is a decimal number instead of an 0H 0M number. What did I do wrong and how can I fix it?
iMac, OS X El Capitan (10.11.1)