AnsweredAssumed Answered

making count by clock time ??

Question asked by HelderSantos_1 on Sep 18, 2012
Latest reply on Sep 19, 2012 by HelderSantos_1


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