Comparing a duration to a decimal number using IF statement gives error.

Question

Level 1

0 points

I have a fairly simple table that contains shift start and end times, subtracts a lunch break, and gives the shift length.

I want to add a column that will calculate if a meal allowance is applicable if the shift duration is > 9.5, add meal allowance, otherwise add zero.

when I use the following

IF(I2> 9.5,17.57,0), where I2 is shift length

it gives the following error

”Durations can’t be compared to other data types”.

How can I get what I need pls?

TIA

iPad Air, iPadOS 16

Posted on Aug 3, 2023 2:49 AM

Reply

Answer 1

Level 6

19,992 points

Hi CRossi62,

Try this:

Formula in J2: IF(I2≥J$1,"Meal allowance","No meal allowance")

Type >= and Numbers will change that to ≥

Regards,

Ian.

Reply

Answer 2

Level 6

19,992 points

Hi again CRossi62,

Perhaps this is a more direct answer to your question:

"Comparing a duration to a decimal number using IF statement gives error."

The function DUR2HOURS is your friend.

Formula in J2: IF(DUR2HOURS(I2)≥9.5,"Meal allowance","No meal allowance")

Regards,

Ian.

Reply

Answer 3

Level 1

0 points

Thank you. This will allow me to put in the actual amount, which is what I wanted.

Reply