free timesheet

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!

excel how-to Learn how to add up hours and create your own templates in ExcelExcel Training