View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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?