Scribd
Upload
1K views9 pages

DTR Computation

The document contains a weekly timesheet template showing pay details for an employee including their name, department, start time, regular hourly pay rate, overtime hourly pay rate, and a table to enter time in/out, hours worked, and total pay by day for a weekly or bi-weekly period. Fields include year, month, date, weekend designation, and spaces to enter daily time tracking and pay calculation details.

Uploaded by

Q Zone
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
1K views9 pages

DTR Computation

The document contains a weekly timesheet template showing pay details for an employee including their name, department, start time, regular hourly pay rate, overtime hourly pay rate, and a table to enter time in/out, hours worked, and total pay by day for a weekly or bi-weekly period. Fields include year, month, date, weekend designation, and spaces to enter daily time tracking and pay calculation details.

Uploaded by

Q Zone
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Year Month Date Weekend

2023 October 16 Sat & Sun

Start Regular Regular Pay Overtime


Time Hours (hourly) Pay (hourly)

6:00 9 65 81.25

Day Date In Time Out Time Break Hrs Regular Hrs OT Hours Total Pay
Mon 16 6:00 21:00 1.0 8.0 6.0 1007.5
Tue 17 6:00 21:00 1.0 8.0 6.0 1007.5
Wed 18 6:00 21:00 1.0 8.0 6.0 1007.5
Thu 19
Fri 20
Sat 21
Sun 22
Mon 23
Tue 24
Wed 25
Thu 26
Fri 27
Sat 28
Sun 29
Mon 30
Tue 31

WSummary 3.0 24.0 18.0 3022.5


WORK TO BE DONE
Weekly TimeSheet Calculator
[Company Name] How to use this template

Employee Name:
Visit TrumpExcel.com
Department:
for more Excel
First Line Manage Templates

Year Month Date Weekend


2021 July 29 Sat & Sun

Start Regular Regular Pay Overtime


Time Hours (hourly) Pay (hourly)
9:00 6.5 30 50

Day Date In Time Out Time Break Hrs Regular Hrs OT Hours Total Pay
Thu 29 9:00 18:00 1.0 6.0 2.0 290.0
Fri 30
Sat 31
Sun 01
Mon 02
Tue 03
Wed 04
Thu 05
Fri 06
Sat 07
Sun 08
Mon 09
Tue 10
Wed 11

Bi-weekly Summary 1.0 6.0 2.0 290.0


mplate
Weekly TimeSheet Calculator
[Company Name] How to use this template

Employee Name:
Visit TrumpExcel.com
Department:
for more Excel
First Line Manage Templates

Year Month Date Weekend


2021 February 1 Sat & Sun

Start Regular Regular Pay Overtime


Time Hours (hourly) Pay (hourly)
9:00 9 30 50

Day Date In Time Out Time Break Hrs Regular Hrs OT Hours Total Pay
Mon 01 9:00 22:00 1.0 8.0 4.0 440.0
Tue 02
Wed 03
Thu 04
Fri 05
Sat 06
Sun 07
Mon 08
Tue 09
Wed 10
Thu 11
Fri 12
Sat 13
Sun 14
Mon 15
Tue 16
Wed 17
Thu 18
Fri 19
Sat 20
Sun 21
Mon 22
Tue 23
Wed 24
Thu 25
Fri 26
Sat 27
Sun 28
Mon 01
Tue 02
Wed 03

Monthly Summary 1.0 8.0 4.0 440.0


mplate
Years Months Days Weekend Check Box
2015 January 1 No Weekend TRUE
2016 February 2 Sat & Sun
2017 March 3 Sun & Mon
2018 April 4 Mon & Tue
2019 May 5 Tue & Wed
2020 June 6 Wed & Thu
2021 July 7 Thu & Fri
2022 August 8 Fri & Sat
2023 Septembe 9 Mon Only
2024 October 10 Tue Only
2025 November 11 Wed Only
December 12 Thu Only
13 Fri Only
14 Sat Only
15 Sun Only
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

You might also like