PK xl/_rels/workbook.xml.rels
PK 0k xl/theme/theme1.xml
PK 3-
xl/styles.xml
PK b xl/worksheets/sheet1.xml
Weekly Timesheet
Enter start and end times and unpaid breaks. Totals and overtime are calculated. Overtime here is hours over 40 in the week (federal rule); some states also have daily overtime.
EmployeeWeek ending
DayDateStartEndUnpaid break (hours)Drive hoursJob hoursTotal paid hours
Monday0.31250.68750.51.56.5IF(AND(C6<>"",D6<>""),(D6-C6)*24-E6,0)
Tuesday0.31250.68750.51.56.5IF(AND(C7<>"",D7<>""),(D7-C7)*24-E7,0)
Wednesday0.31250.68750.51.56.5IF(AND(C8<>"",D8<>""),(D8-C8)*24-E8,0)
Thursday0.31250.68750.51.56.5IF(AND(C9<>"",D9<>""),(D9-C9)*24-E9,0)
Friday0.31250.68750.51.56.5IF(AND(C10<>"",D10<>""),(D10-C10)*24-E10,0)
SaturdayIF(AND(C11<>"",D11<>""),(D11-C11)*24-E11,0)
SundayIF(AND(C12<>"",D12<>""),(D12-C12)*24-E12,0)
Total paid hoursSUM(H6:H12)
Regular hoursMIN(40,H14)
Overtime hoursMAX(0,H14-40)
Hourly rate28
Overtime multiplier1.5
Regular payH15*H18
Overtime payH16*H18*H19
Gross pay for the weekH20+H21
Example values are shown for Monday to Friday. Replace them with your own. Estimate only: bonuses and state rules can change overtime. fieldservice.in
PK ` xl/metadata.xml
PK &E E xl/workbook.xml
PK JjL L _rels/.rels
PK 5 5 docProps/app.xml
SheetJSWorksheets1TimesheetPK ֒|Z Z docProps/core.xml
PK j [Content_Types].xml
PK xl/_rels/workbook.xml.relsPK 0k xl/theme/theme1.xmlPK 3-
xl/styles.xmlPK b *' xl/worksheets/sheet1.xmlPK ` @ xl/metadata.xmlPK &E E D xl/workbook.xmlPK JjL L F _rels/.relsPK 5 5 H docProps/app.xmlPK ֒|Z Z J docProps/core.xmlPK j |L [Content_Types].xmlPK
{ T