Spreadsheet: 706728d1606854376-night-time-differential-mod-function-forum-example
Sheet: Sheet1

 |  |  |  |  |  |  | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Sunday (total hours worked)
EVENTDATE | IN | OUT | day | In | Out | Total hrs worked | 22pm-24pm | 22pm - 6am | 23pm - 6am | 24pm-6am | 22pm-23pm | 00:01-23:59
2020-10-13 00:00:00 | 2020-10-13 16:50:00 | 2020-10-14 01:53:00
2020-11-02 00:00:00 | 2020-11-02 21:57:00 | 2020-11-03 08:02:00
2020-11-01 00:00:00 | 2020-11-01 23:30:00 | 2020-11-02 08:06:00
2020-11-02 00:00:00 | 2020-11-02 21:27:00 | 2020-11-03 08:07:00
2020-11-01 00:00:00 | 2020-11-01 23:27:00 | 2020-11-02 08:08:00
2020-11-03 00:00:00 | 2020-11-03 22:57:00 | 2020-11-04 08:11:00
2020-11-03 00:00:00 | 2020-11-03 22:28:00 | 2020-11-04 08:12:00
2020-10-22 00:00:00 | 2020-10-22 06:54:00 | 2020-10-22 09:23:00
2020-10-24 00:00:00 | 2020-10-24 08:55:00 | 2020-10-24 11:02:00
2020-11-07 00:00:00 | 2020-11-07 08:56:00 | 2020-11-07 11:02:00
2020-10-31 00:00:00 | 2020-10-31 07:56:00 | 2020-10-31 11:08:00
2020-10-15 00:00:00 | 2020-10-15 07:58:00 | 2020-10-15 11:53:00
2020-11-04 00:00:00 | 2020-11-04 16:26:00 | 2020-11-04 22:31:00
2020-10-27 00:00:00 | 2020-10-27 19:33:00 | 2020-10-27 22:31:00
2020-11-06 00:00:00 | 2020-11-06 16:29:00 | 2020-11-06 22:31:00
2020-10-29 00:00:00 | 2020-10-29 18:28:00 | 2020-10-29 22:31:00
2020-10-28 00:00:00 | 2020-10-28 18:30:00 | 2020-10-28 22:31:00
2020-10-19 00:00:00 | 2020-10-19 18:28:00 | 2020-10-19 22:31:00
2020-10-24 00:00:00 | 2020-10-24 18:28:00 | 2020-10-24 22:31:00
2020-11-04 00:00:00 | 2020-11-04 18:29:00 | 2020-11-04 22:31:00
2020-11-06 00:00:00 | 2020-11-06 18:30:00 | 2020-11-06 22:31:00
2020-10-13 00:00:00 | 2020-10-13 18:00:00 | 2020-10-13 23:10:00
2020-10-14 00:00:00 | 2020-10-14 20:11:00 | 2020-10-14 23:11:00
2020-10-14 00:00:00 | 2020-10-14 20:30:00 | 2020-10-14 23:11:00
2020-10-10 00:00:00 | 2020-10-10 18:05:00 | 2020-10-10 23:11:00
2020-10-13 00:00:00 | 2020-10-13 20:56:00 | 2020-10-13 23:11:00
2020-10-14 00:00:00 | 2020-10-14 20:10:00 | 2020-10-14 23:11:00
2020-11-07 00:00:00 | 2020-11-07 18:01:00 | 2020-11-07 23:20:00
2020-11-07 00:00:00 | 2020-11-07 18:00:00 | 2020-11-07 23:20:00
2020-11-07 00:00:00 | 2020-11-07 18:01:00 | 2020-11-07 23:20:00
2020-11-07 00:00:00 | 2020-11-07 19:30:00 | 2020-11-07 23:21:00
2020-11-07 00:00:00 | 2020-11-07 18:01:00 | 2020-11-07 23:21:00
2020-11-07 00:00:00 | 2020-11-07 17:50:00 | 2020-11-07 23:26:00
2020-10-08 00:00:00 | 2020-10-08 19:56:00 | 2020-10-08 23:26:00
2020-11-07 00:00:00 | 2020-11-07 18:57:00 | 2020-11-07 23:26:00
2020-11-01 00:00:00 | 2020-11-01 15:54:00 | 2020-11-01 23:27:00
2020-10-08 00:00:00 | 2020-10-08 20:22:00 | 2020-10-08 23:27:00
2020-10-08 00:00:00 | 2020-10-08 19:56:00 | 2020-10-08 23:27:00
2020-11-01 00:00:00 | 2020-11-01 15:27:00 | 2020-11-01 23:28:00
2020-11-01 00:00:00 | 2020-11-01 17:28:00 | 2020-11-01 23:28:00
2020-10-12 00:00:00 | 2020-10-12 17:56:00 | 2020-10-12 23:29:00
2020-10-12 00:00:00 | 2020-10-12 18:57:00 | 2020-10-12 23:30:00
2020-10-06 00:00:00 | 2020-10-06 19:55:00 | 2020-10-06 23:38:00
2020-10-06 00:00:00 | 2020-10-06 19:23:00 | 2020-10-06 23:39:00
2020-10-06 00:00:00 | 2020-10-06 19:54:00 | 2020-10-06 23:39:00