I have a number fields with a Time (hrs, mins) format. I use this to register game play length. I would like to search for games that take longer/shorter than X hours. How do I format such a search?
I tried creating a Saved Search with “game play” “is less than” “10” but this just gets me one hit which happens to have a time of 0 hrs and 0 min, but none of the games which are actually less than 10 hours. Searching for “is less than” “10 hrs, 0 mins” (mirroring the format of the field itself) has the same result.
Tap Forms stores the Number Format time values in seconds. So when you create your Saved Searches, first convert your time into seconds and put those values into the search rules.
That leads to different results, but still not correct.
10 hours = 36000 seconds. I entered the filter term as “Main story” “is less than” “36000”.
That gives me more results, but some are still more than 10 hrs. I have one that is 11 hrs 30 mins, one that is 10 hrs 30 mins. Etc.
Hmm… ok, I’ll have to look closer into that then.
Can you please email me your form template so that I can experiment with it?
Thanks,
Brendan
.
