Spreadsheet: 819204d1677289727-calculate-difference-between-2-datetimes-in-hours-excluding-weekends-and-holidays-calculate-difference-between-2-datetimes-in-hours-excluding-weekends-and-holidays
Sheet: josephteh

Requested | Solved | Hours Difference | Hours Difference | Start Date falls on Sat/Sun/Hol | End Date  falls on Sat/Sun/Hol | Adj Hours Difference |  | Holidays |  | Shift Start Time | Shift End Time |  | Working Days
2022-08-02 14:30:00 | 2022-10-15 22:02:00 |  |  |  |  |  |  | 2022-08-08 00:00:00 |  | 10:00:00 | 19:00:00 |  | Monday to Friday
2022-08-19 09:43:00 | 2022-09-15 22:02:00 |  |  |  |  |  |  | 2022-08-25 00:00:00
2022-08-19 17:34:00 | 2022-09-01 15:06:00
2022-08-23 14:48:00 | 2022-08-31 17:03:00 |  |  |  |  |  |  | Calculate difference between 2 datetimes in hours excluding Weekends and Holidays
2022-08-23 19:52:00 | 2022-09-15 22:01:00 |  |  |  |  |  |  | Calculate difference between 2 datetimes in hours excluding Weekends and Holidays. (excelforum.com)
2022-08-24 04:46:00 | 2022-09-14 22:45:00
2022-08-24 17:02:00 | 2022-09-02 17:31:00 |  |  |  |  |  |  | Proof of Formula
2022-08-25 22:19:00 | 2022-08-30 13:21:00 |  |  |  |  |  |  |  |  |  | Total Difference
2022-08-26 22:36:00 | 2022-08-31 16:23:00 |  |  |  |  |  |  | Date | Day | Start Time | End Time | Difference
2022-08-26 23:46:00 | 2022-08-31 14:23:00
2022-08-27 01:22:00 | 2022-08-29 22:02:00 |  |  |  |  |  |  | 2022-08-03 00:00:00 | 2022-08-03 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-08-27 01:28:00 | 2022-08-31 20:48:00 |  |  |  |  |  |  | 2022-08-04 00:00:00 | 2022-08-04 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-08-27 01:31:00 | 2022-08-29 22:02:00 |  |  |  |  |  |  | 2022-08-05 00:00:00 | 2022-08-05 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-08-27 01:34:00 | 2022-08-29 22:03:00 |  |  |  |  |  |  | 2022-08-06 00:00:00 | 2022-08-06 00:00:00
2022-08-27 01:38:00 | 2022-08-29 18:57:00 |  |  |  |  |  |  | 2022-08-07 00:00:00 | 2022-08-07 00:00:00
2022-12-26 22:48:00 |  |  |  |  |  |  |  | 2022-08-08 00:00:00 | 2022-08-08 00:00:00
2022-12-27 01:56:00 | 2022-12-29 13:01:00 |  |  |  |  |  |  | 2022-08-09 00:00:00 | 2022-08-09 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-27 12:57:00 | 2022-12-28 20:30:00 |  |  |  |  |  |  | 2022-08-10 00:00:00 | 2022-08-10 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-27 15:17:00 | 2022-12-27 18:38:00 |  |  |  |  |  |  | 2022-08-11 00:00:00 | 2022-08-11 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-27 20:05:00 | 2022-12-28 13:14:00 |  |  |  |  |  |  | 2022-08-12 00:00:00 | 2022-08-12 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-27 20:17:00 | 2022-12-28 14:46:00 |  |  |  |  |  |  | 2022-08-13 00:00:00 | 2022-08-13 00:00:00
2022-12-28 00:20:00 | 2022-12-28 13:24:00 |  |  |  |  |  |  | 2022-08-14 00:00:00 | 2022-08-14 00:00:00
2022-12-28 18:47:00 | 2022-12-28 19:13:00 |  |  |  |  |  |  | 2022-08-15 00:00:00 | 2022-08-15 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-28 21:33:00 | 2022-12-28 21:56:00 |  |  |  |  |  |  | 2022-08-16 00:00:00 | 2022-08-16 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
2022-12-28 22:04:00 | 2022-12-28 22:12:00 |  |  |  |  |  |  | 2022-08-17 00:00:00 | 2022-08-17 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-18 00:00:00 | 2022-08-18 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-19 00:00:00 | 2022-08-19 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-20 00:00:00 | 2022-08-20 00:00:00
 |  |  |  |  |  |  |  | 2022-08-21 00:00:00 | 2022-08-21 00:00:00
 |  |  |  |  |  |  |  | 2022-08-22 00:00:00 | 2022-08-22 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-23 00:00:00 | 2022-08-23 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-24 00:00:00 | 2022-08-24 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-25 00:00:00 | 2022-08-25 00:00:00
 |  |  |  |  |  |  |  | 2022-08-26 00:00:00 | 2022-08-26 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-27 00:00:00 | 2022-08-27 00:00:00
 |  |  |  |  |  |  |  | 2022-08-28 00:00:00 | 2022-08-28 00:00:00
 |  |  |  |  |  |  |  | 2022-08-29 00:00:00 | 2022-08-29 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-30 00:00:00 | 2022-08-30 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-08-31 00:00:00 | 2022-08-31 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-01 00:00:00 | 2022-09-01 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-02 00:00:00 | 2022-09-02 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-03 00:00:00 | 2022-09-03 00:00:00
 |  |  |  |  |  |  |  | 2022-09-04 00:00:00 | 2022-09-04 00:00:00
 |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-06 00:00:00 | 2022-09-06 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-07 00:00:00 | 2022-09-07 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-09 00:00:00 | 2022-09-09 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-10 00:00:00 | 2022-09-10 00:00:00
 |  |  |  |  |  |  |  | 2022-09-11 00:00:00 | 2022-09-11 00:00:00
 |  |  |  |  |  |  |  | 2022-09-12 00:00:00 | 2022-09-12 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-13 00:00:00 | 2022-09-13 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-15 00:00:00 | 2022-09-15 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-16 00:00:00 | 2022-09-16 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-17 00:00:00 | 2022-09-17 00:00:00
 |  |  |  |  |  |  |  | 2022-09-18 00:00:00 | 2022-09-18 00:00:00
 |  |  |  |  |  |  |  | 2022-09-19 00:00:00 | 2022-09-19 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-20 00:00:00 | 2022-09-20 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-21 00:00:00 | 2022-09-21 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-22 00:00:00 | 2022-09-22 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-23 00:00:00 | 2022-09-23 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-24 00:00:00 | 2022-09-24 00:00:00
 |  |  |  |  |  |  |  | 2022-09-25 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  |  |  | 2022-09-26 00:00:00 | 2022-09-26 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-27 00:00:00 | 2022-09-27 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-28 00:00:00 | 2022-09-28 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-29 00:00:00 | 2022-09-29 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-09-30 00:00:00 | 2022-09-30 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-01 00:00:00 | 2022-10-01 00:00:00
 |  |  |  |  |  |  |  | 2022-10-02 00:00:00 | 2022-10-02 00:00:00
 |  |  |  |  |  |  |  | 2022-10-03 00:00:00 | 2022-10-03 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-04 00:00:00 | 2022-10-04 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-05 00:00:00 | 2022-10-05 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-06 00:00:00 | 2022-10-06 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-07 00:00:00 | 2022-10-07 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-08 00:00:00 | 2022-10-08 00:00:00
 |  |  |  |  |  |  |  | 2022-10-09 00:00:00 | 2022-10-09 00:00:00
 |  |  |  |  |  |  |  | 2022-10-10 00:00:00 | 2022-10-10 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-11 00:00:00 | 2022-10-11 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-12 00:00:00 | 2022-10-12 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 10:00:00 | 19:00:00 | 8.999999999999998
 |  |  |  |  |  |  |  | 2022-10-15 00:00:00 | 2022-10-15 00:00:00