
Excel Timesheets | Add & Convert | General Knowledge |
Part A. Create a basic Excel Timesheet | Add up Hours in Excel | How does excel calculate hours |
Part B. Insert Unpaid Lunch Breaks | Convert Conventional Hours into a Decimal # | How does excel calculate dates |
Part C. Calculate Overtime Pay | Convert Hours and Minutes into Minutes | Express Log in and Log out in Excel |
Timesheets for Night Shifts | Average Hours ignoring Zero's and Error Values | Entering only the last 2 digits of a year |
Part B. insert Unpaid lunch breaksHow to create an Excel Timesheet with Lunch Breaks
Step 1:
Create a basic timesheet as described in Part A,
Step 2: Data Entry
Add to columns between the Log In column and the Log out Column
Name them: Lunch Starts and Lunch Ends
Step 3: Calculate Hours worked
In cell F2 type
Method A:
=SUM((C2-B2)+(E2-D2))*24
Time worked before lunch plus time worked after lunch
Method B:
=SUM((E2-B2)-(D2-C2))*24
All time between Log in and Log out, minus lunch time
Date |
Log in |
Lunch Starts |
Lunch Ends |
Log Out |
Total Hours |
Total Pay |
Monday |
9:15 AM |
11:50 AM |
12:20 PM |
5:02 PM |
7.28 |
$80.12 |
Tuesday |
9:20 AM |
11:57 AM |
12:15 PM |
5:00 PM |
7.37 |
$81.03 |
Wednesday |
9:00 AM |
12:00 PM |
12:32 PM |
5:15 PM |
7.72 |
$84.88 |
Thursday |
9:00 AM |
1:00 PM |
1:30 PM |
5:00 PM |
7.50 |
$82.50 |
Friday |
|
|
|
|
0.00 |
$0.00 |
Saturday |
|
|
|
|
0.00 |
$0.00 |
Sunday |
|
|
|
|
0.00 |
$0.00 |
Excel Unscripted.

Template Library Confused? Download our ready to use Excel Templates to add up your hours.
See our Templates

Time Card Calculator Free Online Timecard Calculator. Easy and fast to calculate timesheets.
Try it out!