On 15/01/2011 4:04 a.m., Andy wrote:
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!
Could you have them enter the time using a UF and have separate boxes
for hours and minutes? Then sort out the formatting after.