Hiya,

I'm having problems adding data validation to some cells where the
time can be over 24 hours.

I know that the cells must be formatted [h]:mm to be viewed properly
and have successfully added validation to allow only times of 0:00 and
above (including 24+) by using Time - Greater Than - 00:00:00.

The problem:

If a user types 1 and then hits enter it seems to convert it to days
so the cell shows 24:00.

What I need (if possible) is to force the user to add a colon to make
sure that the number of hours are entered correctly. This could be
anywhere from 00:00 to 100:00+

I have seen code that allows users to enter times without the colon(eg
entering 2300 will show as 23:00 in the cell) but this only applies to
the 24 hour clock and was unable to modify it to suit my needs.

Any help is appreciated!