{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Man Page sbTimeDiff","sbTimeDiff","Shifts_n_Bonuses","TimeTables","Example3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Man Page sbTimeDiff","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Name"]
[]
["sbTimeDiff() - Calculate time between two time points but count only time as specified for week days and for holidays subtracted by break times if working time exceeds specified time"]
[]
["Synopsis"]
[]
["sbTimeDiff(dtFrom, dtTo, vwh [, vHolidays] [, vBreaks])"]
[]
["Description"]
["Calculate time between two time points but count only time as specified for week days and for holidays subtracted by break times if given for specified working time."]
["Example:"]
[null,"dtFrom","2019-04-30T10:45:00"]
[null,"dtTo","2019-05-02T15:12:00"]
[null,"vwh","09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"09:00:00","17:00:00"]
[null,null,"00:00:00","00:00:00"]
[null,"vHolidays","2019-05-01"]
[null,"vBreaks","06:00:00","00:30:00",null,"Subtract 30 min break if working time exceeds 6 hours (but not below 6 hours)"]
[null,null,"09:00:00","00:15:00",null,"Subtract additional 15 min break if working time exceeds 9 hours (but not below 9 hours)"]
[]
[null,"Result","12:00:00","6:15 hours minus 15 minutes break for Tuesday 30/04/2019, no time for holiday 01/05/2019 and 6:12 hours minus 12 minutes break for Thursday 02/05/2019."]
[]
["Options"]
[]
["dtFrom"]
[null,"Datetime to count from"]
[]
["dtTo"]
[null,"Datetime to count to"]
[]
["vwh"]
[null,"8 by 2 matrix defining start time and end time for each weekday, starting with Mondays  (8th row for holidays)"]
[]
["vHolidays"]
[null,"Optional. List of holidays (integer datetime). If a day is in the holiday list its time will"]
[null,"not be counted for any weekday - just for the time defined in row 8 of parameter vwh"]
[]
["vBreaks"]
[null,"Optional. N x 2 matrix specifying working time (sorted in ascending order) and break time to subtract if corresponding time for a day has been worked."]
[]
["See Also"]
[null,"sbTimeAdd"]

{"sheet":"sbTimeDiff","index":1,"n_rows":128,"n_cols":11,"rows_kept":128,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["sbTimeDiff Examples",null,null,null,null,null,"UK Holidays"]
["From","To","Result","Formula","Comment",null,"2019-04-19",null,"Expected correct result","Sign","Difference"]
["2019-12-24T16:00:00","2019-12-29T10:00:00",{"$f":"sbTimeDiff(A3,B3,$B$12:$C$19)","v":1.4166666666690919},{"$f":"sbGetCell(C3,\"FormulaWOT\")","v":"=sbTimeDiff(A3,B3,$B$12:$C$19)"},"No holidays",null,"2019-04-22",null,1.4166666666666667,{"$f":"IF(C3>I3,\"-\",\"\")","v":"-"},{"$f":"ABS(I3-C3)","v":2.4251711749911919E-12}]
["2019-12-24T16:00:00","2019-12-29T10:00:00",{"$f":"sbTimeDiff(A4,B4,$B$12:$C$19,$G$2:$G$128)","v":0.75000000000242539},{"$f":"sbGetCell(C4,\"FormulaWOT\")","v":"=sbTimeDiff(A4,B4,$B$12:$C$19,$G$2:$G$128)"},"With holidays",null,"2019-05-06",null,0.75,{"$f":"IF(C4>I4,\"-\",\"\")","v":"-"},{"$f":"ABS(I4-C4)","v":2.425393219596117E-12}]
["2020-04-05T12:59:00","2020-04-05T19:32:00",{"$f":"sbTimeDiff(A5,B5,$B$12:$C$19)","v":6.9444443943211809E-4},{"$f":"sbGetCell(C5,\"FormulaWOT\")","v":"=sbTimeDiff(A5,B5,$B$12:$C$19)"},"No holidays",null,"2019-05-27",null,6.944444467080757E-4,"",7.2759576141834259E-12]
["2020-04-05T11:30:00","2020-04-05T16:30:00",{"$f":"sbTimeDiff(A6,B6,$B$12:$C$19,$G$2:$G$128)","v":6.25E-2},{"$f":"sbGetCell(C6,\"FormulaWOT\")","v":"=sbTimeDiff(A6,B6,$B$12:$C$19,$G$2:$G$128)"},"With holidays",null,"2019-08-26",null,6.25E-2,"",0]
["2020-04-05T06:29:00","2020-04-06T08:32:00",{"$f":"sbTimeDiff(A7,B7,$B$12:$C$19)","v":0.10555555555523338},{"$f":"sbGetCell(C7,\"FormulaWOT\")","v":"=sbTimeDiff(A7,B7,$B$12:$C$19)"},"No holidays",null,"2019-12-25",null,0.10555555555555556,"",3.2217284395841261E-13]
["2019-12-24T16:00:00","2019-12-29T10:00:00",{"$f":"sbTimeDiff(A8,B8,$B$12:$C$19,$G$2:$G$128)","v":0.75000000000242539},{"$f":"sbGetCell(C8,\"FormulaWOT\")","v":"=sbTimeDiff(A8,B8,$B$12:$C$19,$G$2:$G$128)"},"With holidays",null,"2019-12-26",null,0.75,"-",2.425393219596117E-12]
["2020-09-15T05:30:00","2020-09-18T00:31:00",{"$f":"sbTimeDiff(A9,B9,$B$12:$C$19,,$B$22:$C$23)","v":1.1562499999975748},{"$f":"sbGetCell(C9,\"FormulaWOT\")","v":"=sbTimeDiff(A9,B9,$B$12:$C$19,,$B$22:$C$23)"},"With breaks, no hols",null,"2020-01-01",null,1.1562499999975748,"",0]
[null,null,null,null,null,null,"2020-04-10"]
["Working Hours","Start","End",null,null,null,"2020-04-13"]
["Monday",0.33333333333333331,0.75,null,null,null,"2020-05-04"]
["Tuesday",0.33333333333333331,0.75,null,null,null,"2020-05-25"]
["Wednesday",0.33333333333333331,0.75,null,null,null,"2020-08-31"]
["Thursday",0.33333333333333331,0.75,null,null,null,"2020-12-25"]
["Friday",0.33333333333333331,0.75,null,null,null,"2020-12-28"]
["Saturday",0.41666666666666669,0.5,null,null,null,"2021-01-01"]
["Sunday",0.45833333333333331,0.54166666666666663,null,null,null,"2021-04-02"]
["Holidays",0.5,0.58333333333333337,null,null,null,"2021-04-05"]
[null,null,null,null,null,null,"2021-05-03"]
["Breaks","Limit","Duration",null,null,null,"2021-05-31"]
["First","06:00:00","00:30:00",null,null,null,"2021-08-30"]
["Second","09:00:00","00:15:00",null,null,null,"2021-12-27"]
[null,null,null,null,null,null,"2021-12-28"]
[null,null,null,null,null,null,"2022-01-03"]
[null,null,null,null,null,null,"2022-04-15"]
[null,null,null,null,null,null,"2022-04-18"]
[null,null,null,null,null,null,"2022-05-02"]
[null,null,null,null,null,null,"2022-05-30"]
[null,null,null,null,null,null,"2022-08-29"]
[null,null,null,null,null,null,"2022-12-26"]
[null,null,null,null,null,null,"2022-12-27"]
[null,null,null,null,null,null,"2023-01-02"]
[null,null,null,null,null,null,"2023-04-07"]
[null,null,null,null,null,null,"2023-04-10"]
[null,null,null,null,null,null,"2023-05-01"]
[null,null,null,null,null,null,"2023-05-29"]
[null,null,null,null,null,null,"2023-08-28"]
[null,null,null,null,null,null,"2023-12-25"]
[null,null,null,null,null,null,"2023-12-26"]
[null,null,null,null,null,null,"2024-01-01"]
[null,null,null,null,null,null,"2024-03-29"]
[null,null,null,null,null,null,"2024-04-01"]
[null,null,null,null,null,null,"2024-05-06"]
[null,null,null,null,null,null,"2024-05-27"]
[null,null,null,null,null,null,"2024-08-26"]
[null,null,null,null,null,null,"2024-12-25"]
[null,null,null,null,null,null,"2024-12-26"]
[null,null,null,null,null,null,"2025-01-01"]
[null,null,null,null,null,null,"2025-04-18"]
[null,null,null,null,null,null,"2025-04-21"]
[null,null,null,null,null,null,"2025-05-05"]
[null,null,null,null,null,null,"2025-05-26"]
[null,null,null,null,null,null,"2025-08-25"]
[null,null,null,null,null,null,"2025-12-25"]
[null,null,null,null,null,null,"2025-12-26"]
[null,null,null,null,null,null,"2026-01-01"]
[null,null,null,null,null,null,"2026-04-03"]
[null,null,null,null,null,null,"2026-04-06"]
[null,null,null,null,null,null,"2026-05-04"]
[null,null,null,null,null,null,"2026-05-25"]
[null,null,null,null,null,null,"2026-08-31"]
[null,null,null,null,null,null,"2026-12-25"]
[null,null,null,null,null,null,"2026-12-28"]
[null,null,null,null,null,null,"2027-01-01"]
[null,null,null,null,null,null,"2027-03-26"]
[null,null,null,null,null,null,"2027-03-29"]
[null,null,null,null,null,null,"2027-05-03"]
[null,null,null,null,null,null,"2027-05-31"]
[null,null,null,null,null,null,"2027-08-30"]
[null,null,null,null,null,null,"2027-12-27"]
[null,null,null,null,null,null,"2027-12-28"]
[null,null,null,null,null,null,"2028-01-03"]
[null,null,null,null,null,null,"2028-04-14"]
[null,null,null,null,null,null,"2028-04-17"]
[null,null,null,null,null,null,"2028-05-01"]
[null,null,null,null,null,null,"2028-05-29"]
[null,null,null,null,null,null,"2028-08-28"]
[null,null,null,null,null,null,"2028-12-25"]
[null,null,null,null,null,null,"2028-12-26"]
[null,null,null,null,null,null,"2029-01-01"]
[null,null,null,null,null,null,"2029-03-30"]
[null,null,null,null,null,null,"2029-04-02"]
[null,null,null,null,null,null,"2029-05-07"]
[null,null,null,null,null,null,"2029-05-28"]
[null,null,null,null,null,null,"2029-08-27"]
[null,null,null,null,null,null,"2029-12-25"]
[null,null,null,null,null,null,"2029-12-26"]
[null,null,null,null,null,null,"2030-01-01"]
[null,null,null,null,null,null,"2030-04-19"]
[null,null,null,null,null,null,"2030-04-22"]
[null,null,null,null,null,null,"2030-05-06"]
[null,null,null,null,null,null,"2030-05-27"]
[null,null,null,null,null,null,"2030-08-26"]
[null,null,null,null,null,null,"2030-12-25"]
[null,null,null,null,null,null,"2030-12-26"]
[null,null,null,null,null,null,"2031-01-01"]
[null,null,null,null,null,null,"2031-04-11"]
[null,null,null,null,null,null,"2031-04-14"]
[null,null,null,null,null,null,"2031-05-05"]
[null,null,null,null,null,null,"2031-05-26"]
[null,null,null,null,null,null,"2031-08-25"]
[null,null,null,null,null,null,"2031-12-25"]
[null,null,null,null,null,null,"2031-12-26"]
[null,null,null,null,null,null,"2032-01-01"]
[null,null,null,null,null,null,"2032-03-26"]
[null,null,null,null,null,null,"2032-03-29"]
[null,null,null,null,null,null,"2032-05-03"]
[null,null,null,null,null,null,"2032-05-31"]
[null,null,null,null,null,null,"2032-08-30"]
[null,null,null,null,null,null,"2032-12-27"]
[null,null,null,null,null,null,"2032-12-28"]
[null,null,null,null,null,null,"2033-01-03"]
[null,null,null,null,null,null,"2033-04-15"]
[null,null,null,null,null,null,"2033-04-18"]
[null,null,null,null,null,null,"2033-05-02"]
[null,null,null,null,null,null,"2033-05-30"]
[null,null,null,null,null,null,"2033-08-29"]
[null,null,null,null,null,null,"2033-12-26"]
[null,null,null,null,null,null,"2033-12-27"]
[null,null,null,null,null,null,"2034-01-02"]
[null,null,null,null,null,null,"2034-04-07"]
[null,null,null,null,null,null,"2034-04-10"]
[null,null,null,null,null,null,"2034-05-01"]
[null,null,null,null,null,null,"2034-05-29"]
[null,null,null,null,null,null,"2034-08-28"]
[null,null,null,null,null,null,"2034-12-25"]
[null,null,null,null,null,null,"2034-12-26"]

{"sheet":"Shifts_n_Bonuses","index":2,"n_rows":15,"n_cols":26,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonus Weekdays",null,null,"Bonus Weekends",null,null,"Bonus Bank Holidays"]
[null,null,null,null,"Time Weekdays",null,null,"Time Weekends",null,null,"Time Bank Holidays",null,null,"Night","Early","Late","Night","Early","Late","Night","Early","Late",null,null,"Checksums"]
["Name","Day","Shift Start","Shift End","Night","Early","Late","Night","Early","Late","Night","Early","Late",2,0,1,2,0,1,4,2,3,"Bonus Total",null,"Total Time","Total Time summed up"]
["John","2020-08-30",0.33333333333333331,0.70833333333333337,{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WD_Night,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WD_Early,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WD_Late,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WE_Night,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WE_Early,Holidays)","v":0.33333333332848269},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),WE_Late,Holidays)","v":4.1666666671517305E-2},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),BH_Night,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),BH_Early,Holidays)","v":0},{"$f":"sbTimeDiff($B4+$C4,$B4+$D4+($D4<$C4),BH_Late,Holidays)","v":0},{"$f":"N$3*E4*24","v":0},{"$f":"O$3*F4*24","v":0},{"$f":"P$3*G4*24","v":0},{"$f":"Q$3*H4*24","v":0},{"$f":"R$3*I4*24","v":0},{"$f":"S$3*J4*24","v":1.0000000001164153},{"$f":"T$3*K4*24","v":0},{"$f":"U$3*L4*24","v":0},{"$f":"V$3*M4*24","v":0},{"$f":"SUM(N4:V4)","v":1.0000000001164153},null,{"$f":"-$C4+$D4+($D4<$C4)","v":0.37500000000000006},{"$f":"SUM(E4:M4)","v":0.375}]
["Jane","2020-08-30",0.95833333333333337,0.33333333333333331,0,0,0,0,0,4.1666666664241347E-2,0.33333333333575865,2.4253377084448857E-12,0,{"$f":"N$3*E5*24","v":0},0,0,0,0,0.99999999994179234,32.000000000232831,1.1641621000535451E-10,0,{"$f":"SUM(N5:V5)","v":33.000000000291038},null,{"$f":"-$C5+$D5+($D5<$C5)","v":0.375},{"$f":"SUM(E5:M5)","v":0.37500000000242534}]
["Dave","2020-08-30",0.70833333333333337,0.95833333333333337,0,0,0,0,0,0.25,0,0,0,0,0,0,0,0,6,0,0,0,6,null,0.25,0.25]
["Robot","2020-08-30",0,1,0,0,0,0.33333333333333215,0.3333333333309092,0.33333333333575865,0,0,0,0,0,0,15.999999999999943,0,8.0000000000582077,0,0,0,24.000000000058151,null,1,1]
["John","2020-08-31",0.33333333333333331,0.70833333333333337,0,0,0,0,0,0,0,0.33333333332848269,4.1666666671517305E-2,0,0,0,0,0,0,0,15.999999999767169,3.000000000349246,19.000000000116415,null,0.37500000000000006,0.375]
["Jane","2020-08-31",0.95833333333333337,0.33333333333333331,0.33333333333575865,2.4253377084448857E-12,0,0,0,0,0,0,4.1666666664241347E-2,16.000000000116415,0,0,0,0,0,0,0,2.999999999825377,18.999999999941792,null,0.375,0.37500000000242534]
["Dave","2020-08-31",0.70833333333333337,0.95833333333333337,0,0,0,0,0,0,0,0,0.25,0,0,0,0,0,0,0,0,18,18,null,0.25,0.25]
["Robot","2020-08-31",0,1,0,0,0,0,0,0,0.33333333333333215,0.3333333333309092,0.33333333333575865,0,0,0,0,0,0,31.999999999999886,15.999999999883642,24.000000000174623,72.000000000058151,null,1,1]
["John","2020-09-01",0.33333333333333331,0.70833333333333337,0,0.33333333332848269,4.1666666671517305E-2,0,0,0,0,0,0,0,0,1.0000000001164153,0,0,0,0,0,0,1.0000000001164153,null,0.37500000000000006,0.375]
["Jane","2020-09-01",0.95833333333333337,0.33333333333333331,0.33333333333575865,2.4253377084448857E-12,4.1666666664241347E-2,0,0,0,0,0,0,16.000000000116415,0,0.99999999994179234,0,0,0,0,0,0,17.000000000058208,null,0.375,0.37500000000242534]
["Dave","2020-09-01",0.70833333333333337,0.95833333333333337,0,0,0.25,0,0,0,0,0,0,0,0,6,0,0,0,0,0,0,6,null,0.25,0.25]
["Robot","2020-09-01",0,1,0.33333333333333215,0.3333333333309092,0.33333333333575865,0,0,0,0,0,0,15.999999999999943,0,8.0000000000582077,0,0,0,0,0,0,24.000000000058151,null,1,1]

{"sheet":"TimeTables","index":3,"n_rows":128,"n_cols":13,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["Weekdays",null,null,null,"Weekends",null,null,null,"Bank Holidays",null,null,null,"UK Holidays"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-19"]
["Night Shift","Start","End",null,"Night Shift","Start","End",null,"Night Shift","Start","End",null,"2019-04-22"]
["Monday",0,0.33333333333333331,null,"Monday",null,null,null,"Monday",null,null,null,"2019-05-06"]
["Tuesday",0,0.33333333333333331,null,"Tuesday",null,null,null,"Tuesday",null,null,null,"2019-05-27"]
["Wednesday",0,0.33333333333333331,null,"Wednesday",null,null,null,"Wednesday",null,null,null,"2019-08-26"]
["Thursday",0,0.33333333333333331,null,"Thursday",null,null,null,"Thursday",null,null,null,"2019-12-25"]
["Friday",0,0.33333333333333331,null,"Friday",null,null,null,"Friday",null,null,null,"2019-12-26"]
["Saturday",null,null,null,"Saturday",0,0.33333333333333331,null,"Saturday",null,null,null,"2020-01-01"]
["Sunday",null,null,null,"Sunday",0,0.33333333333333331,null,"Sunday",null,null,null,"2020-04-10"]
["Holidays",null,null,null,"Holidays",null,null,null,"Holidays",0,0.33333333333333331,null,"2020-04-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-04"]
["Early Shift","Start","End",null,"Early Shift","Start","End",null,"Early Shift","Start","End",null,"2020-05-25"]
["Monday",0.33333333333333331,0.66666666666666663,null,"Monday",null,null,null,"Monday",null,null,null,"2020-08-31"]
["Tuesday",0.33333333333333331,0.66666666666666663,null,"Tuesday",null,null,null,"Tuesday",null,null,null,"2020-12-25"]
["Wednesday",0.33333333333333331,0.66666666666666663,null,"Wednesday",null,null,null,"Wednesday",null,null,null,"2020-12-28"]
["Thursday",0.33333333333333331,0.66666666666666663,null,"Thursday",null,null,null,"Thursday",null,null,null,"2021-01-01"]
["Friday",0.33333333333333331,0.66666666666666663,null,"Friday",null,null,null,"Friday",null,null,null,"2021-04-02"]
["Saturday",null,null,null,"Saturday",0.33333333333333331,0.66666666666666663,null,"Saturday",null,null,null,"2021-04-05"]
["Sunday",null,null,null,"Sunday",0.33333333333333331,0.66666666666666663,null,"Sunday",null,null,null,"2021-05-03"]
["Holidays",null,null,null,"Holidays",null,null,null,"Holidays",0.33333333333333331,0.66666666666666663,null,"2021-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-30"]
["Late Shift","Start","End",null,"Late Shift","Start","End",null,"Late Shift","Start","End",null,"2021-12-27"]
["Monday",0.66666666666666663,1,null,"Monday",null,null,null,"Monday",null,null,null,"2021-12-28"]
["Tuesday",0.66666666666666663,1,null,"Tuesday",null,null,null,"Tuesday",null,null,null,"2022-01-03"]
["Wednesday",0.66666666666666663,1,null,"Wednesday",null,null,null,"Wednesday",null,null,null,"2022-04-15"]
["Thursday",0.66666666666666663,1,null,"Thursday",null,null,null,"Thursday",null,null,null,"2022-04-18"]
["Friday",0.66666666666666663,1,null,"Friday",null,null,null,"Friday",null,null,null,"2022-05-02"]
["Saturday",null,null,null,"Saturday",0.66666666666666663,1,null,"Saturday",null,null,null,"2022-05-30"]
["Sunday",null,null,null,"Sunday",0.66666666666666663,1,null,"Sunday",null,null,null,"2022-08-29"]
["Holidays",null,null,null,"Holidays",null,null,null,"Holidays",0.66666666666666663,1,null,"2022-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-05-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-05-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-08-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2025-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-05-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-05-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-08-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2026-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-03-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-03-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-05-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-08-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2027-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-01-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-04-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-05-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-08-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2028-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-03-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-04-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-05-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-05-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-08-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2029-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-04-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-04-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-05-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-05-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-08-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2030-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-04-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-05-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-05-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-08-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2031-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-03-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-03-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-05-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-08-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2032-12-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-01-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-04-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-05-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-05-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-08-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2033-12-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-01-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-04-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-04-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-05-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-08-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2034-12-26"]

{"sheet":"Example3","index":4,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Received","Called","Response Time",null,null,"Working Hours","Start","End",null,"US Holidays"]
["2020-08-22T20:44:00","2020-08-24T11:05:00",{"$f":"sbTimeDiff(A2,B2,Work_Hours,US_Holidays)","v":8.6805555554747116E-2},null,null,"Monday",0.375,0.875,null,"2020-01-01"]
["2020-08-23T14:04:00","2020-08-24T18:35:00",{"$f":"sbTimeDiff(A3,B3,Work_Hours,US_Holidays)","v":0.39930555555474712},null,null,"Tuesday",0.375,0.875,null,"2020-01-20"]
["2020-08-21T17:16:00","2020-08-25T09:45:00",{"$f":"sbTimeDiff(A4,B4,Work_Hours,US_Holidays)","v":0.53125},"Mon 12h + Tue 45 mins = 12:45",null,"Wednesday",0.375,0.875,null,"2020-02-17"]
["2020-09-03T14:41:00","2020-09-08T12:21:00",{"$f":"sbTimeDiff(A5,B5,Work_Hours,US_Holidays)","v":0.73611111110706895},null,null,"Thursday",0.375,0.875,null,"2020-05-25"]
["2020-08-23T11:11:00","2020-08-29T17:17:00",{"$f":"sbTimeDiff(A6,B6,Work_Hours,US_Holidays)","v":2.3333333333333335},"A full week w/o holidays = 56h",null,"Friday",0.375,0.70833333333333337,null,"2020-07-03"]
[null,null,null,null,null,"Saturday",null,null,null,"2020-09-07"]
[null,null,null,null,null,"Sunday",null,null,null,"2020-10-12"]
[null,null,null,null,null,"Holidays",null,null,null,"2020-11-11"]
[null,null,null,null,null,null,null,null,null,"2020-11-26"]
[null,null,null,null,null,null,null,null,null,"2020-12-25"]
[null,null,null,null,null,null,null,null,null,"2021-01-01"]
[null,null,null,null,null,null,null,null,null,"2021-01-18"]
[null,null,null,null,null,null,null,null,null,"2021-02-15"]
[null,null,null,null,null,null,null,null,null,"2021-05-31"]
[null,null,null,null,null,null,null,null,null,"2021-07-05"]
[null,null,null,null,null,null,null,null,null,"2021-09-06"]
[null,null,null,null,null,null,null,null,null,"2021-10-11"]
[null,null,null,null,null,null,null,null,null,"2021-11-11"]
[null,null,null,null,null,null,null,null,null,"2021-11-25"]
[null,null,null,null,null,null,null,null,null,"2021-12-24"]
[null,null,null,null,null,null,null,null,null,"2021-12-31"]