Greater Than But Less Than Formula For Time

Connie Cochran

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

Paul Newcome

Smartsheet is unable to calculate time directly. Here is a thread with a lot of time based formulas. You should be able to grab something from there and tweak it.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Hollie Green

The easiest solution would be to add the date to the column and reference the date instead of the time.

=If(DATE[approved event start time]@row=DATE[Approved event end time]@row,"Yes")

If you can't then you will need to create some helper columns to develop your if formula.

See https://community.smartsheet.com/discussion/65268/change-time-into-military for how to convert to military time