Thanks for your replies. I’m not sure at all about the “INT” function. I need to learn more about where I could use it.
Lupp, I’ve read some of your answers, over the years and I’ve learnt from them but without delving too much (yet) into this one, while appreciated, I find it a bit more confusing on this occasion.
Opaque, your answer was more than a hint as it worked ‘straight out of the box’. I modified it slightly to suit my purposes, so I’ve used “=IF(ISNUMBER(J11),INT(NOW()-J11) & “d, " & HOUR(NOW()-J11) & “:” & MINUTE(NOW()-J11),””)".
Your second formula certainly shows up my error in column “I”. I’ve changed that from “=IF(ISNUMBER(H11),DAYS(NOW(),H11),”")" to “=IF(AND(ISNUMBER(H10),ISNUMBER(J10)),J10-H10,IF(ISNUMBER(H10),DAYS(NOW(),H10),”"))". I’ll need to do the same with the formulae in column “K” later.
Once again, thanks for your replies.
Off to look at “INT” now.