Help

Formula to Identify Time Ranges

Topic Labels: Formulas
194 2
cancel
Showing results for 
Search instead for 
Did you mean: 
KGB
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!

I have a formula field that calculates the number of hours between two date fields. I want to then parse this into categories based on the duration:

A = hours ae greater than 96

B = hours are greater than 24, but less than 96

C = all remaining positive values less than 24

D = hours are negative

Thank you!!

2 Replies 2

Try:

IF(
  Hours <= 24, "A"
) & 
IF(
  AND(
    Hours > 24,
    Hours <= 96
  ),
  "B"
) & 
IF(
  Hours > 96, "C"
) 

Screenshot 2024-06-27 at 9.00.04 PM.png

 

Alexey_Gusev_0-1719712407205.png