I have a column of 100 cells each containing 23:59 (hh:mm) and I want to autosum the values and format the answer in dd:hh:mm to give a result of 99 days 22 hrs 20 mins - how do I format the formula cell?
Not too sure this could be done with a Custom Number Format, but I didn't look into it too deep.
You could however use a formula to display the result, but perform any further calculations (if any) on the orgiginal total.
I gave it a quick test and it seems to work.
Yes this does give the right answer; I'll experiment with different values to ensure it works correctly before using it in anger. Thank you for the assistance.:tumble: