How to use ExcelOctober 9, 2024

    Time Sheet in Excel

    Time Sheet in Excel

    This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. If you are in a hurry simply download the Excel file.

    1. To automatically calculate the next 4 days and dates when you enter a start date use the formulas below.

    Date Formulas

    2. Select the cells containing the times.

    Select Time Cells

    3. Right click click Format Cells and select the right Time format. Use the circled format for cell K12 K13 and K14.

    Time Format

    4. To automatically calculate the hours worked each day the total hours and the overtime hours use the formulas below.

    Time Formulas

    Written by

    Jason Howie

    Founder, FormulasHQ

    A formula nerd with a passion for numbers and equations. Writes about Excel, Google Sheets, VBA, regex, and Salesforce formulas — for people who spend their day in spreadsheets.

    Try FormulasHQ →
    ← All articles