Skip to main content

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!!

Try:

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

 


 


Reply