I am trying to compute the downtime and have a formula that subtracts the on task time, transit and wait time from 24 hours. However if the sum of the calculation equals 24 hours then I get #####s in the cell; if it equals 00:00:01 then it will display correctly ie 00:00. Is there a way of showing zero downtime as 00:00 when the calculation returns a value of 00:00:00. I have tried different formats of the results cell (hh;mm and [h]:mm) but it makes no difference.
Help appreciated
Help appreciated