Thanks simarui, The first formula works but I can't get any joy from the second. It points to unpopulated cells but still provides a reply, if i change the cells, it makes no difference always Y.

This is a bit of a digression from my initial request but would it be possible, based on the outcome of the calculation to change the cell colours of, for example A4 - I4? if it was over 4 hours?