Forum Discussion
Data validation formula to return 24hr time or N/a
Hi, I'm wondering if some kind person might be able to provide some assistance. I need a field in Excel to either accept the value "N/a" or time (in 24hour format) when entered directly into the cel...
Hi Scott,
Just format C13 with 24 hours time format and in data validation formula check if number entered is between 0 and 1. That's equivalent of time between 00:00 and 24:00, more exactly another representation of it.
Just format C13 with 24 hours time format and in data validation formula check if number entered is between 0 and 1. That's equivalent of time between 00:00 and 24:00, more exactly another representation of it.
And here is the formula
=ISNUMBER(C13)*(C13<=1)+(C13="N/A")