Free · No sign-up · Works on your phone

Timesheet calculator

Build your weekly timesheet: shifts, breaks, totals in hours and minutes and in decimal hours, with optional rounding. Then print it, save it as a PDF or download a spreadsheet.

    Pay, overtime and rounding
    Total hours0:00
    Gross pay
    Hours and pay for each day
    DayHoursDecimalPay

    Keeping a record every week? Clockbook for iPhone clocks you in with one tap and works this out for you. Coming soon to the App Store.

    Your entries stay in this browser. Nothing is sent to us.

    How to use it

    1. Add each shift with its start time, finish time and unpaid break.
    2. If your employer rounds time, choose 5, 6 or 15 minutes. Each shift is rounded to the nearest step after breaks are taken off.
    3. Download a CSV for Excel, Numbers or Google Sheets, or print it and choose Save as PDF.

    Worked example: rounding to 15 minutes

    1. Monday, 8:53 to 17:08 with a 30-minute break: 7 hours 45 minutes exactly.
    2. Tuesday, 8:56 to 17:04 with a 30-minute break: 7 hours 38 minutes.
    3. Rounded to the nearest 15 minutes, Tuesday becomes 7 hours 45 minutes, because 7:38 is closer to 7:45 than to 7:30.
    4. Both days count as 7.75 hours on the timesheet.

    Result: 15 hours 30 minutes (15.50 hours) over two days

    Questions

    What does rounding to 6 minutes mean?

    Six minutes is a tenth of an hour, so time is counted in steps of 0.1 hours. A shift of 7 hours 38 minutes rounds to 7 hours 36 minutes, or 7.6 hours.

    Should I round my own timesheet?

    Only if your employer rounds time and tells you the step they use. Otherwise leave rounding off and record the exact minutes.

    Can I open the timesheet in Excel?

    Yes. Download the CSV and it opens in Excel, Numbers or Google Sheets, with one row per shift and a totals row.

    More free calculators