Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Need to mark a record based on a time range

Topic Labels: Formulas
Solved
Jump to Solution
169 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a table where I need to mark when flights take off between 22:00 - 07:00. I would like an If statement where it marks the record with an X when this is true. I have date fields for the departure time but I just cant quite find how to have a general standing marker based on times rather that a specific time AND date.

1 Solution

Accepted Solutions
Kevin_Bower
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey kevin! Its kevin, I figured it out for you. Converted the times to decimals.

IF(OR({Departure Time (Airport Time)} < 7.0,

{Departure Time (Airport Time)} > 22.0), ‘x’, BLANK())

See Solution in Thread

2 Replies 2
Kevin_Bower
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey kevin! Its kevin, I figured it out for you. Converted the times to decimals.

IF(OR({Departure Time (Airport Time)} < 7.0,

{Departure Time (Airport Time)} > 22.0), ‘x’, BLANK())

You could also use the HOUR() function to pull the hour out of a time field.