Spreadsheet: 684872d1593595002-calculate-hours-present-and-overtime-for-attendance-overtime
Sheet: OverTime

Date | SHV KUMAR |  | Working Hours | Hours Present | Addl. Hours Worked |  |  |  |  |  | HARISH |  |  | KUMAR |  |  |  |  | Days Present | Declared Holiday(s)
 | IN | OUT |  |  |  |  |  |  |  |  | IN | OUT |  | IN | OUT |  | AV00023 | Shiv Kumar |  | 0
2020-06-01 00:00:00 | 09:30:00 | 22:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 21:10:00 |  | AV00025 | Harish |  | 0
2020-06-02 00:00:00 | 09:30:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 14:30:00 |  | 09:30:00 | 21:14:00 |  | AV00024 | [NAME] |  | 0
2020-06-03 00:00:00 | 09:30:00 | 23:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 20:00:00 |  | 09:00:00 | 20:50:00
2020-06-04 00:00:00 | 09:30:00 | 01:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 20:30:00 |  | 09:00:00 | 17:00:00
2020-06-05 00:00:00 | 09:30:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 21:10:00
2020-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 20:00:00 |  | 09:30:00 | 21:00:00
2020-06-07 00:00:00 | 09:30:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 14:30:00 |  | 09:00:00 | 21:30:00
2020-06-08 00:00:00 | 09:45:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 21:00:00 |  | 09:00:00 | 20:50:00
2020-06-09 00:00:00 | 09:30:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 21:00:00 |  | 09:10:00 | 21:00:00
2020-06-10 00:00:00 | 09:30:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 19:00:00 |  | 09:30:00 | 21:10:00
2020-06-11 00:00:00 | 09:30:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 19:00:00 |  | 10:00:00 | 21:40:00
2020-06-12 00:00:00 | 09:45:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:00:00 |  | 09:10:00 | 22:00:00
2020-06-13 00:00:00 | 09:45:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:00:00 |  | 10:00:00 | 22:10:00
2020-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 22:00:00
2020-06-15 00:00:00 | 10:00:00 | 18:00:00 | 10 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 21:40:00
2020-06-16 00:00:00 | 09:45:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 19:00:00 |  | 09:30:00 | 21:30:00
2020-06-17 00:00:00 | 09:45:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:10:00 | 21:20:00
2020-06-18 00:00:00 | 09:45:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 21:40:00
2020-06-19 00:00:00 | 10:00:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:20:00 | 21:30:00
2020-06-20 00:00:00 | 10:00:00 | 18:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 21:30:00
2020-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 21:30:00
2020-06-22 00:00:00 | 10:00:00 | 18:30:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 10:00:00 | 21:10:00
2020-06-23 00:00:00 | 10:00:00 | 19:00:00 | 10 |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:00:00 | 20:30:00
2020-06-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:30:00 | 21:30:00
2020-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 20:50:00
2020-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 10:00:00 | 21:00:00
2020-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:30:00 | 20:50:00
2020-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 21:45:00
2020-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 | 18:30:00 |  | 09:40:00 | 20:45:00
2020-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  | 10:00:00