Forum Discussion

Rob Nunley's avatar
Rob Nunley
Brass Contributor
Apr 06, 2020

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(Submitted),DAY(Submitted)),"hh:mm")

This gives me just the time from the "Submitted" field.  I would like to have a calculated Yes/No field that would return the value "yes" if "HelperTime" is greater that 14:00 and "no" otherwise.  I am using the following formula but it is not working:

=IF(HelperTime>14,"Yes","No")

If i use 14:00 in above formula it get an error message.

 

SharePoint Online
Time
  • DhaniCole's avatar
    DhaniCole
    Brass Contributor
    Apr 25, 2020

    Rob Nunley 

    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")

Resources