L
Lynne
I am trying to set up a time sheet showing hours worked by job and phase.
The template for "Employee Absence Tracker" is the general format that I want
to use with some modifications.
I have added two new columns on the left side of the worksheet for "Job" and
"Phase" and I have added several more rows.
On the "Total" worksheet, I need to insert a function that will show totals
of hours for each job and phase entered in the monthly worksheets, for
example:
Job #154, Phase #2, July 10 hours
Job #150, Phase #3, July 8 hours
Can anyone tell me how?
The template for "Employee Absence Tracker" is the general format that I want
to use with some modifications.
I have added two new columns on the left side of the worksheet for "Job" and
"Phase" and I have added several more rows.
On the "Total" worksheet, I need to insert a function that will show totals
of hours for each job and phase entered in the monthly worksheets, for
example:
Job #154, Phase #2, July 10 hours
Job #150, Phase #3, July 8 hours
Can anyone tell me how?