Spreadsheet: 790620d1659889443-calculate-the-employees-reduced-work-hours-employee-hours
Sheet: 2022-07-01 - 2022-07-31

Date | Days | Status | Check in time | Check in Time | Check in status | Check in location | Check in address | Check out time | Check out status | Check out location | Check out address | Total Hours | Overtime | Late check in note | Left early note | [NAME] |  | Hour | Minute |  | Total Hours | Total Number of hour less worked
2022-07-01 |  | Weekend | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-02 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-03 |  | Present | 09:42 am |  | On time | Office IP | Corporate Office | 07:31 pm | Left timely | Office IP | Corporate Office | 9 hr 49 min | - |  |  | No
2022-07-04 |  | Present | 10:24 am |  | On time | Office IP | Corporate Office | - | - | - | - | - | - |  |  | No
2022-07-05 |  | Present | 11:34 am |  | On time | Office IP | Corporate Office | 07:49 pm | Left timely | Office IP | Corporate Office | 8 hr 14 min | - |  |  | No
2022-07-06 |  | Present | 10:07 am |  | On time | Office IP | Corporate Office | 07:39 pm | Left timely | Office IP | Corporate Office | 9 hr 31 min | - |  |  | No
2022-07-07 |  | Present | 10:14 am |  | On time | Office IP | Corporate Office | 05:58 pm | Left timely | Office IP | Corporate Office | 7 hr 44 min | - |  |  | No |  | 19 |  |  | 19:44:00 | 00:16:00
2022-07-08 |  | Weekend | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-09 |  | Holiday | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-10 |  | Holiday | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-11 |  | Holiday | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-12 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-13 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-14 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-15 |  | Weekend | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-16 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-17 |  | Present | 12:59 pm |  | On time | Office IP | Corporate Office | 07:17 pm | Left timely | Office IP | Corporate Office | 6 hr 17 min | - |  |  | No |  | 18 |  |  | 18:17:00 | 02:43:00
2022-07-18 |  | Present | 09:57 am |  | On time | Office IP | Corporate Office | 07:28 pm | Left timely | Office IP | Corporate Office | 9 hr 31 min | - |  |  | No
2022-07-19 |  | Present | 12:34 pm |  | On time | Office IP | Corporate Office | 07:17 pm | Left timely | Office IP | Corporate Office | 6 hr 43 min | - |  |  | No |  | 16 |  |  | 16:43:00 | 02:17:00
2022-07-20 |  | Present | 11:36 am |  | On time | Remote | [NAME], HB Tower, House 1/A, Road 23, Gulshan 1, Gulshan, Dhaka | 07:43 pm | Left timely | Remote | - | 8 hr 7 min | - |  |  | No
2022-07-21 |  | Present | 01:27 pm |  | On time | Office IP | Corporate Office | 07:22 pm | Left timely | Office IP | Corporate Office | 5 hr 54 min | - |  |  | No |  | 17 |  |  | 17:54:00 | 03:06:00
2022-07-22 |  | Weekend | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-23 |  | Present | 01:35 pm |  | On time | Office IP | Corporate Office | 07:16 pm | Left timely | Office IP | Corporate Office | 5 hr 40 min | - |  |  | No |  | 17 |  |  | 17:40:00 | 03:20:00
2022-07-24 |  | Present | 01:45 pm |  | On time | Office IP | Corporate Office | 09:14 pm | Left timely | Office IP | Corporate Office | 7 hr 28 min | - |  |  | No |  | 19 |  |  | 19:28:00 | 00:32:00
2022-07-25 |  | Present | 09:53 am |  | On time | Office IP | Corporate Office | 08:18 pm | Left timely | Office IP | Corporate Office | 10 hr 25 min | - |  |  | No
2022-07-26 |  | Present | 02:23 pm |  | On time | Office IP | Corporate Office | 08:39 pm | Left timely | Office IP | Corporate Office | 6 hr 15 min | - |  |  | No |  | 18 |  |  | 18:15:00 | 02:45:00
2022-07-27 |  | Present | 01:19 pm |  | On time | Office IP | Corporate Office | 08:29 pm | Left timely | Office IP | Corporate Office | 7 hr 10 min | - |  |  | No |  | 19 |  |  | 19:10:00 | 00:50:00
2022-07-28 |  | Present | 01:24 pm |  | On time | Office IP | Corporate Office | 09:56 pm | Left timely | Office IP | Corporate Office | 8 hr 32 min | - |  |  | No
2022-07-29 |  | Weekend | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-30 |  | Absent | - |  | - | - | - | - | - | - | - | - | - |  |  | -
2022-07-31 |  | Present | 12:54 pm |  | On time | Office IP | Corporate Office | 08:23 pm | Left timely | Office IP | Corporate Office | 7 hr 28 min | - |  |  | No |  | 19 |  |  | 19:28:00 | 00:32:00