making count by clock time ??
I have a database that records the day and time that the employee has a meal.
how can count how many breakfast, lunch and Dinners each employee has taken per month?
breakfast from 7:00 to 9:00, Lunch 12:00 to 15:00, Dinner 19:00 to 21:00
do i have to user (am) and (pm) for time format?
the table has a field for day and one for the time