Elapsed Time for Productivity / Adding back time for Lunch Breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database to measure warehouse picking productivity using "elapsed
time". Pickers log in(form inputs= Employee ID, Order #, # of order lines to
pick with a time/date stamp) and Log out(form inputs= Order # with time/date
stamp) after the order is picked.
My Tables are: Employee Data,Picking Data, and break Schedule.

My Question: How would I add back time for lunch breaks, etc to the "elapsed
time" calculation?

Thanks in advance for your help!
 
I created a database to measure warehouse picking productivity using "elapsed
time". Pickers log in(form inputs= Employee ID, Order #, # of order lines to
pick with a time/date stamp) and Log out(form inputs= Order # with time/date
stamp) after the order is picked.
My Tables are: Employee Data,Picking Data, and break Schedule.

My Question: How would I add back time for lunch breaks, etc to the "elapsed
time" calculation?
Click to expand...

Well, that depends on how you have than information stored.

Off the wall suggestion: just make breaks another Order type. Just as
the worker logs the start and end of an ordinary order, they could log
the start and end of a break. The Order # would be the same for all
lunch breaks, etc.

John W. Vinson[MVP]
 
Back
Top