Spreadsheet: 886554d1736588090-timesheet-calculation-formula-template
Sheet: trial

 |  |  |  |  |  |  |  |  |  | Payroll of Month : | 2025-01-01 00:00:00
Employee Name | : |  |  |  |  |  |  |  | cutoff 1pm |  | Sat = OT start 1pm | cutoff 5pm | cutoff 5pm | cutoff 1pm = is 4hrs work and 1hr rest
Passport No | : |  |  |  |  |  |  |  | Sunday
Department | : |  |  |  |  |  |  |  | < 4hr = 0.5 |  | normal day work | PH < 8 hrs | PH >= 8 hrs
Company | : |  |  |  |  |  |  |  | > 4hr = 0
Basic Wages | : | 1500
Account No | :
 |  |  |  |  |  |  |  |  | ok | ok |  |  | ok
Date |  | Day | HIDE THIS COLUMN |  | Clock In | Clock Out | Working Hours | HIDE THIS COLUMN | OT 0.5 | OT 1.0 | OT 1.5 | OT 2.0 | OT 3.0
 |  |  |  |  | 08:00:00 | 17:00:00
 |  |  |  |  | 08:00:00 | 14:00:00 |  |  |  |  |  |  |  |  | supposedly
 |  |  |  |  | 08:00:00 | 08:00:00 |  |  |  |  |  |  |  |  | OT 2.0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hours need
 |  |  |  | PH | 08:00:00 | 09:00:00 |  |  |  |  |  |  |  |  | 1
 |  |  |  | PH | 08:00:00 | 10:00:00 |  |  |  |  |  |  |  |  | 2
 |  |  |  | PH | 08:00:00 | 11:00:00 |  |  |  |  |  |  |  |  | 3
 |  |  |  | PH | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  | 4
 |  |  |  | PH | 08:00:00 | 13:00:00 |  |  |  |  |  |  |  |  | 4
 |  |  |  | PH | 08:00:00 | 14:00:00 |  |  |  |  |  |  |  |  | 5
 |  |  |  | PH | 08:00:00 | 15:00:00 |  |  |  |  |  |  |  |  | 6
 |  |  |  | PH | 08:00:00 | 16:00:00 |  |  |  |  |  |  |  |  | 7
 |  |  |  | PH | 08:00:00 | 17:00:00 |  |  |  |  |  |  |  |  | 8
 |  |  |  | PH | 08:00:00 | 18:00:00 |  |  |  |  |  |  |  |  | 9
 |  |  |  | PH | 08:00:00 | 19:00:00 |  |  |  |  |  |  |  |  | 10
 |  |  |  | PH | 08:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | 11
 |  |  |  | PH | 08:00:00 | 21:00:00 |  |  |  |  |  |  |  |  | 12
 |  |  |  | PH | 08:00:00 | 22:00:00 |  |  |  |  |  |  |  |  | 13
 |  |  |  | PH | 08:00:00 | 23:00:00 |  |  |  |  |  |  |  |  | 14
 |  |  |  | PH | 08:00:00 | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | 15
 |  |  |  | PH | 08:00:00 | 1900-01-01 01:00:00 |  |  |  |  |  |  |  |  | 16
 |  |  |  | PH | 08:00:00 | 1900-01-01 02:00:00 |  |  |  |  |  |  |  |  | 17
 |  |  |  | PH | 08:00:00 | 1900-01-01 03:00:00 |  |  |  |  |  |  |  |  | 18
 |  |  |  | PH | 08:00:00 | 1900-01-01 04:00:00 |  |  |  |  |  |  |  |  | 19
 |  |  |  | PH | 08:00:00 | 1900-01-01 05:00:00 |  |  |  |  |  |  |  |  | 20
 |  |  |  | PH | 08:00:00 | 1900-01-01 06:00:00 |  |  |  |  |  |  |  |  | 21
 |  |  |  | PH | 08:00:00 | 1900-01-01 07:00:00 |  |  |  |  |  |  |  |  | 22
 |  |  |  | PH | 08:00:00 | 1900-01-01 08:00:00 |  |  |  |  |  |  |  |  | 23
 |  |  |  | PH | 08:00:00 | 1900-01-01 09:00:00 |  |  |  |  |  |  |  |  | 24
 |  |  |  | PH | 08:00:00 | 1900-01-01 10:00:00 |  |  |  |  |  |  |  |  | 25
 |  |  |  | PH | 08:00:00 | 1900-01-01 11:00:00 |  |  |  |  |  |  |  |  | 26
 |  |  |  | PH | 08:00:00 | 1900-01-01 12:00:00 |  |  |  |  |  |  |  |  | 27
 |  |  |  | PH | 08:00:00 | 1900-01-01 13:00:00 |  |  |  |  |  |  |  |  | 28
 |  |  |  | PH | 08:00:00 | 1900-01-01 14:00:00 |  |  |  |  |  |  |  |  | 29
 |  |  |  | PH | 08:00:00 | 1900-01-01 15:00:00 |  |  |  |  |  |  |  |  | 30
Work | :
Extra Work | :
Total Work Day | :
PH | :
Restday | :