Forum Discussion
Solved
Help Please with an IF Statement with Time Values to create Interval Groups
Hi all, My apologies in advance as I haven't ever asked a question using this community before but wanted to say "thank you" to the community because this support group has helped me out several ...
This seems like a good case to use a SWITCH statement in a calculated column.
Something like this should get you pointed in the right direction. (I used [Time] as the column with times in it where you had [Helper].)
_condition =SWITCH(TRUE(),AND([Time] >= TIME(7,30,0), [Time] <= TIME(10,30,0)), "Breakfast",AND([Time] >= TIME(12,0,0), [Time] <= TIME(15,30,0)), "Lunch",AND([Time] >= TIME(16,30,0), [Time] <= TIME(18,30,0)), "Snacks",AND([Time] >= TIME(19,30,0), [Time] <= TIME(23,0,0)), "Dinner",AND([Time] >= TIME(0,0,0), [Time] <= TIME(4,0,0)), "Midnight","Other Snacks")
jgeddes
Super User
Super UserThis seems like a good case to use a SWITCH statement in a calculated column.
Something like this should get you pointed in the right direction. (I used [Time] as the column with times in it where you had [Helper].)
_condition =
SWITCH(
TRUE(),
AND([Time] >= TIME(7,30,0), [Time] <= TIME(10,30,0)), "Breakfast",
AND([Time] >= TIME(12,0,0), [Time] <= TIME(15,30,0)), "Lunch",
AND([Time] >= TIME(16,30,0), [Time] <= TIME(18,30,0)), "Snacks",
AND([Time] >= TIME(19,30,0), [Time] <= TIME(23,0,0)), "Dinner",
AND([Time] >= TIME(0,0,0), [Time] <= TIME(4,0,0)), "Midnight",
"Other Snacks"
)
Hello! Oh my goodness, it is working now!!! Thank you so much!