Time Clock

G

gobarr

I have developed a form in which users can clock in and out for th
purposes of recording the amout of time employees have worked. Thi
form simply asks for the user to type in a number (ClockInNumber) an
then you can press the button "clock in" or "clock out". The table tha
this information is sent to is simply 4 fields: ClockInNumber
TimeInOut, InOut, and Date where ClockInNumber is simply their punch i
number, TimeInOut is where the current time is stored(e.g. "8:00 AM")
InOut is a field who's value is set to "IN" or "OUT" depending on whic
button they press, and Date is where the current date is set(e.g
"5/5/04"). I am trying to figure out a way to add up all the times fo
each employee. I am not sure how to get it to add up the times betwee
each "IN" and "OUT" pair for each employee for a particular 2 wee
cycle. I havn't even been able to find a way to add up their hours fo
a particular day. Given that a particular employee may punch in an ou
more than once during each day to allow for lunch, it can get kind o
complex or at least in my head it does
 
Top