A better way to create this function. To long for Data Validation.
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
|