Forum Discussion
Time and Yes/No
I have a Date/Time Field named "Submitted" in format mm/dd/yyyy hh:mm. I have another calculated field named "HelperTime" with the following formula: =TEXT(Submitted-DATE(YEAR(Submitted),MONTH(Subm...
Looks like you helper time is a text string, so you need to convert it to time. Try:
=IF(TIME(LEFT(Helpertime,2),RIGHT(Helpertime,2),0)>TIME(14,0,0),"Yes","No")