= IF(AND(a 1 & gt； =7/24，a 1 & lt； =(8+5/6)/24), "Breakfast", if (and (a1>; = 1 1/24，a 1 & lt； = 12.5/24), "lunch", if (and (a1> = 17/24，a 1 & lt； = 18.5/24), "Dinner", ""))
The formula for calculating breakfast times is as follows:
=COUNTIF(B:B，D2)