You can't really restrict how users enter information, just the result of
their input. For instance let's say you use data validation and select
"time", "less than or equal to", and enter "12:00 PM". A user can enter 4:48
or 0.2 and get the same result (4:48 AM). Data validation won't restrict
either input. In fact this data validation is the same as selecting
"decimal", "less than or equal to", and entering "1".

"Smudge" wrote:

Hi,

I have a column that adds time which has been formatted to HH:MM in custom
format. Just noticed that once the result reaches 24 hours then it restarts
at zero. Not exactly what I had in mind! Could anyone suggest a workaround
for this please.

Whilst I'm here... I wanted to do a data validation for this range to ensure
that users enter times as HH:MM but couldn't figure out how to do it Time did
not seem to be the right option as users will be adding discreet amounts of
time rather than entering a specific time. Couldn't figure how to use custom;
tried HH:MM but think I'm barking up the wrong tree.
Any help would be very much appreciated.

TIA
--
Smudge