Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need to mark a record based on a time range

Topic Labels: Formulas
Solved
Jump to Solution
1324 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Bower
5 - Automation Enthusiast
5 - Automation Enthusiast

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.