Hello all,

I'm trying to work out elapsed time in excel using a start time and a dynamic clock. I want any times that exceed 24 hours from the 'In Order' time to turn the cell red. I can get it to work out elapsed time using the following formula =IF(D5 ="","",$J$4-D5) , but when the time is input as 23:00 it returns #####.


The image below should explain what im trying to achieve:-
dynamic clock.png

Any ideas what I can do in this instance? Is the formula i'm using any good?

Thank you.