I have a field which records time in hh;mm:ss format, in the column next to it i want to determine whether or not the time is less than 30 secs (00:00:30), if it is the formulae should calculate to 1, if not 0
But i can't get it to work in any format?
Bookmarks