Yes you can, though there will be some work involved. Anything can be converted to a string by concatenating it with another string. In the case of the duration field, it’s going to return the duration in seconds, so 1:00 becomes 3600, 2:00 becomes 7200, etc. Do some math to convert that back into hours and minutes, then concatenate it with the rest of your data in the formula. Not exactly easy, but doable.

Actually, using a string for the time would be much simpler than all the math required with a duration field. Use `DATETIME_PARSE()`

, building the string to parse by combining the formatted version of today’s date with the time from the `{From}`

or `{To}`

field. Here a test I ran using this method:

Here’s the formula in `{Parsed From}`

. `{Parsed To}`

does the same with the `{To}`

field.

`DATETIME_PARSE(DATETIME_FORMAT(NOW(), "MM/DD/YYYY ") & From, "MM/DD/YYYY h:mmA")`

Add another formula field to see if the current time falls between the `{Parsed From}`

and `{Parsed To}`

values.