You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am creating a schedule template in Numbers that automatically calculates meal breaks. I want to create an if, then formula in numbers. If the result is ≤4 hours, then leave blank. If the result is ≥5 hours, but <8 hours, then 30 minutes. If the result is ≥8, then 60m.
Also, how do I total up the number of scheduled hours without the "-" sign?
MacBook Pro (2017 – 2020)
Hi rjschu,
I know this is an older post, but I thought I'd work on it.
Comparing durations can get a little tricky since Numbers will want to compare similar data types. Since you already defined what breaks durations are, I came up with a solution to use those as inputs to compare to in a new column (column G for example). Once I did that, I came up with this formula to match your criteria for the break durations.
IFS($C3≥$G$3,$G$5,$C3≤$G$2,$G$6,$C3<$G$3,$G$4)
I think that should work for you.
Also, for your second question. It seems you may be subtracting column A from column B for each respective row (just a guess from the screenshot you provided). This creates a negative value. Instead, change it to subtract B from A for each respective row and you'll get a positive number instead.
Numbers: IF, THEN statements