Wednesday, October 2, 2013

Column validation formula for time value only input in a single line of text field.

Here is a Column validation formula for time value only input in a single line of text field:
=TIMEVALUE(TimeText)<>TEXT(TimeText;"hh:mm")

Geplaatst door op
Labels: , ,

2 comments:

  1. Anonymous01 September, 2014 09:19

    Hello
    There is small correction in formula like =TIMEVALUE(TimeText)<>TEXT(TimeText,"HH:MM").We need to use , instead of .
    Other wise we will run into error

    ReplyDelete
    Replies
    1. Hans Worst17 September, 2014 12:35

      Thanks for the tip. I use another localization, that's why.

      Delete

Subscribe to: Post Comments (Atom)