Our free timesheet calculator will then create a simple time sheet report with totals for your daily and/or weekly employee work hours. Timesheet Controls. Calculate. The calculator automatically totals up all work hours and attendance entries, while generating the timesheet report to help with payroll. Reset Let’s say you work in an office and want to keep track of your hours to so your employer can pay the correct amount due. You work 5 days a week, so you need to go to the customization panel on the right side. Under the days and weeks tab, click on the drop down that says Days per Work Week, and select 5 days/week. Jan 06, 2016 · I'm the question asker. To do a time calculation where you can have 1 hour 38 minutes and multiply that with a pay rate: 1. In one cell, format it as duration (Format -> Number -> Duration). Make it count Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks.