Greater Than But Less Than Formula For Time

Connie Cochran
Connie Cochran ✭✭✭✭
edited 06/14/23 in Formulas and Functions

I'm trying to build a formula that looks at times in two columns to see if it spans two dates aka starts before midnight and ends after midnight but my formula isn't working. Any suggestions to correct my formula or to write it differently?

=IF(And([Approved event start time]@row>= 12:00 AM, [Approved event end time]@row<= 12:00 PM], "Yes")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!