Read this to get started using the Excel Timesheet.
| 1. | First, you select the ‘Settings’ sheet to input relevant data values. All cells with blue text colors can be edited. Further down, you find various other options, such as ‘Work Schedule’, ‘Flexible Time Limits’, etc. All cells highlighted in yellow contain ON/OFF flags that activate when you click on them. |
| 2. | When ‘Settings’ is finished, you go to the ‘Calendar’ sheet where you input the current year, select the first day of the week, and choose which days should be ‘red days’ and/or holidays. You continue by specifying national and regional days by clicking inside the yellow cells. If a holiday is not listed, it can be hardcoded near the bottom (see some examples of Excel syntax in the footnotes). |
| 3. | In order to define your projects, you go to the ‘Projects’ sheet. You start by deleting the seven example projects (select the cells with descriptions and dates, and press ‘delete’), and then type in your own projects. Finally, go to the sheet for the current month and press the button labeled ‘PROJECTS’ in order for the newly defined entries to show up. |
| 4. | You may now start logging your work hours. First, locate the tab for the current month, and press it. You will see that there is a separate column for each date in the month. Editable data is shown in blue fonts, such as overtime and vacation. Cells that are auto-calculated are shown in black fonts, such as extra time and flexible time. The first data to be filed each day is ‘Regular Time’ (unless ‘Work Schedule’ in ‘Settings’ is set to OFF). After that, other relevant cells for that day become accessible. Note that clock-in and clock-out times are input using the format ‘hh:mm’, including the colon, even though they are displayed without the colon in order to save space. Examples: ’08:45′ and ’16:30′ Hours that are worked on a certain day, can be logged against the individual projects, or against vacation, sick leave, or granted leave. Hours exceeding regular time may be logged against overtime. |
| 5. | For certain cells, a brief content description is displayed when the cell is selected. Such descriptions are provided within the sheets ‘Settings’, ‘Calendar’, ‘Projects’, and ‘Jan’. Example: By selecting the cell ‘Regular Time’, an explanation appears, describing the cell content. |
| 6. | The company name and website address can be inserted in the headers of the sheets for each month by selecting ‘Text’ -> ‘Header & Footer’ under the ‘Insert’ menu. (To edit all months simultaneously, select all the sheets by pressing the ‘Jan’ tab and holding SHIFT while pressing the ‘Dec’ tab.) |
| 7. | The VBA-disabled edition of the workbook has the file extension xlsx, and the VBA-enabled edition has the file extension xlsm. In order to use the pushbuttons, one will need to activate macros upon opening the VBA-enabled edition. |
| 8. | For more information, see User Manual, or go to Videos. |
Go back to Frontpage