Hi everyone,
I'm trying to write a short statement to change the time if it is greater than 6:00:00 but it doesn't work. The data I have always 6:00:10 or more.
I have tried this but no good:
If range("a1","a4:a6","a7","a10:a15") > 6:00:00 then
range("a1","a4:a6","a7","a10:a15") = 6:00:00
End if
Could anyone please help! Thanks
TD
I'm trying to write a short statement to change the time if it is greater than 6:00:00 but it doesn't work. The data I have always 6:00:10 or more.
I have tried this but no good:
If range("a1","a4:a6","a7","a10:a15") > 6:00:00 then
range("a1","a4:a6","a7","a10:a15") = 6:00:00
End if
Could anyone please help! Thanks
TD