Instructions
Open Microsoft Access.
Open a new database. You may be prompted to give the database a name. Using the dates the spreadsheet will cover is an effective title because it makes searching through databases much easier.
Enter the hours worked. You may find it helpful to list the days of the week or dates down the first left column, with the hours worked before lunch next to each day, and the hours worked after lunch after this. Total the hours worked in the last column.
Day Worked Before Lunch After Lunch Total
Monday ________5_________6_______11
Tuesday ________4_________5_______9
Highlight the "Total" column.
Click the "Autosum" button on the toolbar. This looks like a backward "3."
How to Calculate Hours in Access 2007
Filling in time sheets or calculating hours can be quite difficult if you are working strictly off the top of your head. To save yourself the headache, you can use a program such as Microsoft Access, which can store and calculate hours worked and make it much easier to check that your pay is correct as well as provide you with a record of hours worked every month.