On 16/08/2010 19:07, ManicMiner17 wrote:
Another issue is there doesn't seem to be any non time validation now.
What I mean by this is if I type some text into the cell the code
doesn't have a problem with it.

Hi Andy,

Not sure what is happening at your end. If I type "Andy" into one of the
cells it throws up the "invalid time" message box and clears the cell.

I've just looked for valid times. Everything else is an invalid time
which includes text.