Hi

Format as Custom "[hh]:mm:ss" (or "[h]:mm:ss"), you were said! It makes a
difference :-)


--
(When sending e-mail, use address )
Arvi Laanemets


"Niklas" wrote in message
...
The highest time Data Validation accepts is 23:59:59 or have I missed
something?
Regards
/Niklas

----- arno wrote: -----

Hi Niklas,

In a text cell I want to check if the user have entered a valid
interval.
A valid intervall looks like this 33:01:00.

why don't you use a cell that is formatted as time, [hh]:mm:ss? then
you
only have to validate data (menu Data) to be less than the "time"
100:00:00.

regards

arno