Timesheet coding & calculating
I'm assuming you have this formatted as a table.
Just sort by the employee code, then go to Data--Subtotals and subtotal by
employee code and date.
Dave
--
Brevity is the soul of wit.
"vtrud" wrote:
I am creating a timesheet that I need to track daily logs of employees time.
We have codes and mark in half hour increments. My problem is that I would
like to do this all on the computer rather than by hand and when doing it by
time and code I don't know how to create a function where I can make it
automatically total for each code on a daily and then weekly basis. Does
anyone have any ideas?
|