| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Totals in a Workbook
Hi,
I have a workbook where each sheet represents one week. I have employees listed in rows and the column headings are "Hours Worked", Overtime, Sick Time, etc. I have a Totals page that I need to tally each week (total hours) for any or all columns. I also have blank pages "Start" and "End". On the Totals page for the calculation - =Sum(Start:End!B4). All pages are formatted under the [h]:mm:ss. I need to be able to insert a new sheet each week. Can anyone tell me why this doesn't work? Thanks in advance. Judy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Totals in a Workbook
I also keep receiving a "circular reference" error any time the file is opened.
"judyblue" wrote: Hi, I have a workbook where each sheet represents one week. I have employees listed in rows and the column headings are "Hours Worked", Overtime, Sick Time, etc. I have a Totals page that I need to tally each week (total hours) for any or all columns. I also have blank pages "Start" and "End". On the Totals page for the calculation - =Sum(Start:End!B4). All pages are formatted under the [h]:mm:ss. I need to be able to insert a new sheet each week. Can anyone tell me why this doesn't work? Thanks in advance. Judy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop time seems dependent on unrelated workbook - Why? | Excel Worksheet Functions | |||
| Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Why does Excel 2003 open on 3rd tab of workbook every time, not l. | Excel Worksheet Functions | |||
| sort tabs in a workbook other than one at a time with move or cop. | Excel Worksheet Functions | |||
Linear Mode
