This is the third version of the original 2-column time sheet calculator, which I added in response to a request asking for a fourth in/out column.
If this is your first time here, be sure to check out the following features.
Up until now, adding up your time sheet hours was probably a real pain.
Because most offline and hand-held calculators don't have a ":" (colon) key to represent hours and minutes. Hence you have to convert the minutes into tenths of hours before you can add up work hours.
And just like the other versions, this calculator also enables you to enter times without any special characters at all!. And you can even enter times as military times if you want. And again, no punctuation required.
And you will also be pleased to see there are no drop-down time or AM/PM menus to slow you down, nor will you never need to hit the back button or wait for the page to reload to recalculate. All the magic happens on this page!
Simply enter the in and out times for each day of the weekly payroll period and the calculator will ...
If you use an offline calculator to add up work hours you will spend extra time converting minutes into 10ths of hours (15 minutes = .25 hours).
No more! The time sheet calculator on this page will automatically convert minutes to 10ths of hours.
The weekly time sheet calculator also includes a Printer Friendly Report so you can print out a work-hours and gross wages report for each employee -- without printing everything else on this web page.
Not only will this save time and printer ink, but you will also impress the payroll clerk or accountant with how neat and easy-to-read your hour and wage reports are compared to those that are still submitting hand-written reports.
If you are using a newer version of your web browser software (one that supports HTML5 Local Storage), you can now save your entries between visits -- either for yourself or for multiple employees.
However, please keep in mind that the saved entries can only be accessed from the device and web browser they were saved with. Also, Local Storage is not 100% reliable, and no backup method exists, so be sure to keep your paper records.
If you would like to save multiple time sheets to a secure database -- making them accessible across all of your devices and web browsers -- please see the Ad-Free Cloud Version of this website.
Here are the other versions currently available in case the time entry calculator on this page doesn't meet your needs:
If neither the calculator on this page or any of the above options accommodate your needs please contact me and specify what you need and I will consider creating another version.
With that, let's use the 4-column time sheet calculator to calculate time sheet hours and gross weekly wages.
Check Out My Other Super
Wage & Salary Calculators
To Help You To
Calculate Your ...
Employee name: Optional: If you will be printing the completed time sheet report for a specific employee, enter their name here.
If your web browser supports Local Storage, you can also add multiple employees to the drop-down list, and then save their individual in-out times between visits.
To add an employee, select New, enter the name, and then click the Add button.
To add/edit in-out times for an employee, select their name from the menu, enter/edit the in-out times, and then click the Save Changes button. If you don't want an employees wage info saved, leave the wage fields blank when saving changes.
To remove an employee from the list, select the employee name and click the Delete button.
Hourly pay rate: Optional: Enter the regular hourly rate of pay for the employee you are entering in/out times for. If you are using the local storage feature, and you don't want the wage to appear for each employee, leave this field blank when saving changes to the employee.
Overtime rate: Optional: Select the Overtime option that best fits your pay situation. If you receive overtime pay, enter the factor that your regular rate is multiplied by and the time sheet calculator will calculate your hourly overtime rate for you. Or, simply enter your overtime rate in the far right-hand field.
Day of the week your workweek starts on: Optional: Select the day of the week you want the time sheet calculator to start at. The Day column will automatically be filled in with the correct days. If you want to include the date in each Day field (e.g. Mon Jul 2), select the month and day of the first day of the payroll period. If you don't want the date included, select N/A from the month drop-down menu.
Time totals as hours:minutes or hours.hour-fraction? If you would like the time totals formatted to hours and minutes, select HH:MM (7 and 1/2 hours will appear as 7:30). Or, if you would like the time totals formatted to hours and fraction of an hour, select HH.HH (7 and 1/2 hours will appear as 7.50). Note that you can switch from one to the other format at anytime during time entry process, at which time the calculator will automatically reformat the daily totals.
Time entry format: When entering In/Out times, you can enter the time with or without the colon (:). For blocks of time that cover 12 or more hours (6:00 am to 6:00 pm), please use military times (600 to 1800) per the military conversion chart link in the instruction section of the calculator. The printer friendly report will reformat your entries to include the colons, regardless of how you enter the times.
Military time format: If you need to enter a time block that is 12 or more hours in length, please use the military time conversion chart to look up the military times you will need to enter ("0000" will not be read by the calculator).
Day column: You can change the text in this column to whatever identifier you would like to show up on the report.
Block 1 column: This period is normally the period before lunch break.
Block 2 column: This period is either for the period after lunch, or for times when you need to leave work for an appointment.
Block 3 column: This period normally only contains times on those days where you had to leave for an appointment.
Block 4 column: This period will accommodate workplaces that have three unpaid breaks throughout the workday.
HH:MM/HH.HH column: This calculated column will total up your hours:minutes (or hours.hour) for each day, and then total up the hours:minutes (or hours.hour) for the week. Fields in this column recalculate as you enter or change times in the time sheet.
Regular row: This row contains your regular hourly rate, your total regular hours for the week, and your total regular wages.
Overtime row: This row contains your overtime hourly rate, your total overtime hours for the week, and your total overtime wages.
Total row: This row contains your total hours and wages for the week.
Save Current Settings button: Click this button to save the overtime preference, hour format, and payroll period settings between visits.
Clear Sheets for New Pay Period button: Click this button to clear in-out times from all employee time sheets so you can start a new payroll period.
Clear All Data button: Click this button to delete all saved settings, employees, and in-out times.
Printer Friendly Time Sheet Report button: Clicking this button will open the displayed form in a new window for printing. If you need to email the form to a payroll clerk, your printer should have an option to print the report to a PDF file (saves PDF file to your hard drive). You can then attach the PDF file to the email you send to the clerk.