Time Sheet Design Help

[Harriet]

I am trying to design a database timesheet/clock for a department that needs
to track daily time in, lunch out, lunch in, daily time out.

I don't want the associates to be able to manipulate the time in any way and
started with using the date/time stamp from the system but with that field,
I'm not finding that I'm able to calculate the hours worked for an employee
as I'm creating 4 records for that day and I'd like to somehow create one
record for the employee for a given day.

They basically need to be able to go and 'punch in' and 'out' when the time
comes and have that time 'stamped' from the system and not manually put it in
themselves.

Is there a way to set this up so that the employee can enter their time
in/out or have 4 entries for one day or even just two if no lunch, and have
that time 'stamped', like a "Now()" so that they not enter the time (honesty
issues) AND be able to calculate the hours worked in a report? I don't want
any times to change or update upon entering the record again.

Thank you so much!

Harriet White

 

[Keven Denen]

I am trying to design a database timesheet/clock for a department that needs
to track daily time in, lunch out, lunch in, daily time out.

I don't want the associates to be able to manipulate the time in any way and
started with using the date/time stamp from the system but with that field,
I'm not finding that I'm able to calculate the hours worked for an employee
as I'm creating 4 records for that day and I'd like to somehow create one
record for the employee for a given day.

They basically need to be able to go and 'punch in' and 'out' when the time
comes and have that time 'stamped' from the system and not manually put it in
themselves.

Is there a way to set this up so that the employee can enter their time
in/out or have 4 entries for one day or even just two if no lunch, and have
that time 'stamped',  like a "Now()" so that they not enter the time (honesty
issues) AND be able to calculate the hours worked in a report?  I don'twant
any times to change or update upon entering the record again.

Thank you so much!

Harriet White

You already posted this question and I responded in the other thread.

All the people who respond here are volunteers, so don't expect
answers immediately. And don't post your question over and over if you
don't get an immediate response.

Keven Denen