Date | Time In | Time Out | total working hrs | |
01 | 2022-12-01 06:29:17 | 2022-12-01 19:01:49 | 12 | 7am - 7pm |
02 | 2022-12-02 07:40:43 | 2022-12-02 20:00:37 | 12 | 8am - 8pm |
03 | 2022-12-03 07:47:51 | 2022-12-03 19:19:02 | 11 | 8am to 7pm |
04 | 2022-12-04 07:34:03 | 2022-12-04 19:45:41 | ||
05 | 2022-12-05 07:44:44 | 2022-12-05 19:00:19 | ||
06 | 2022-12-06 07:34:50 | 2022-12-06 19:36:08 | ||
07 | 2022-12-07 07:44:34 | 2022-12-07 19:02:16 | ||
08 | N/A | N/A | ||
09 | 2022-12-09 07:38:25 | 2022-12-10 08:29:41 | ||
10 | 2022-12-10 18:50:45 | 2022-12-11 07:35:28 | ||
11 | 2022-12-11 19:00:46 | 2022-12-12 07:03:46 | ||
12 | 2022-12-12 18:29:37 | 2022-12-13 07:02:08 | ||
13 | 2022-12-13 18:39:03 | 2022-12-14 07:02:06 | ||
14 | N/A | N/A | ||
15 | N/A | N/A | ||
16 | 2022-12-16 07:37:45 | 2022-12-16 19:02:20 | ||
17 | 2022-12-17 07:47:40 | 2022-12-18 08:00:07 | ||
18 | 2022-12-18 18:38:28 | 2022-12-19 07:00:56 | ||
19 | 2022-12-19 18:37:55 | 2022-12-20 07:02:52 | ||
20 | 2022-12-20 18:55:36 | 2022-12-21 07:05:14 | ||
21 | 2022-12-21 18:48:20 | 2022-12-22 07:01:53 |
how to calculate working hours using formula
Question Info
Last updated April 13, 2025 Views 29 Applies to: