Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a worksheet set up as a monthly record of hours worked:
Example Date Job No. Hours worked 01/02 2167 4 2000 2.5 2412 1.5 (total C1:C3) 8 This runs throughout the month; each day is calculated and the summary of the hours worked appears at the end, using (9,C4:Cn), e.g 160. On the next page of the same worksheet, I need the total of hours worked during the month for each job, e.g: Job No. Hours 2000 22 2167 14 2412 2 etc ... Total .....160 Is there a way to calculate/add up all the hours worked during the month for each job to enter on Page 2 rather than, as I do now, going through each day and writing down each job and the hours worked on it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Timesheet calculations | Excel Discussion (Misc queries) | |||
TIMESHEET | Excel Worksheet Functions | |||
Timesheet calculations | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet Calculations | Excel Worksheet Functions |