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:
Posts by harryaliasjames
-
-
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?