Timesheet coding & calculating
 

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?

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?

Timesheet coding & calculating
 

Not coded by employee, coded by task program. These are repeated daily. I
copied some here. It is in a spreadsheet at this point.

NAME Week Ending

Weekly Summary Time Sat Sun Mon Tues Wed Thurs Fri
Proj # Hours Hrs Over 40 6:30
7:00
100 7:30
200 8:00
300 8:30
400 9:00
450 9:30
500 10:00
600 10:30
701 11:00
705 11:30
709 12:00
710 12:30
715 1:00
719 1:30
700 2:00



"Dave F" wrote:

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?