{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sheet2","入力用シート","集計用シート","単月（あとでコピー)","単月（あとで月数分コピー）","テスト","Sheet1","祝日判定マスタ","単月(いじる用） (✕✕✕)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":1},"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":"Sheet2","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"入力用シート","index":1,"n_rows":5,"n_cols":25,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"①要入力",null,null,"              ②要入力",null,"       ③要入力",null,"非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！"]
[null,"No","日付","曜日","祝日","               開始時刻",null,"                  終了時刻",null,"時間外判別","土日祝判定","開始時刻","終了時刻","全分数","時間外(m)","通常(m)","時間外(h)ベース","通常(h)ベース","A 平日\n(時間内)","B 土日祝","C 時間外",null,"A 平日\n(時間内)","B 土日祝","C 時間外"]
[null,{"$f":"ROW()-4","v":0},null,{"$f":"IF(C4=\"\",\"\",TEXT(C4,\"aaaa\"))","v":""},{"$f":"IFERROR(VLOOKUP(C4,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":""},{"$f":"IF(E4<>\"\",\"土日祝\",IF(OR(D4=\"土曜日\",D4=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F4,\"時\",\"\")), VALUE(SUBSTITUTE(G4,\"分\",\"\")), 0),\"\")","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H4,\"時\",\"\")),VALUE(SUBSTITUTE(I4,\"分\",\"\")),0),\"\")","v":""},{"$f":"IF(OR(M4=\"\",L4=\"\"),\"\", (M4 - L4) * 1440)","v":""},{"$f":"IFERROR(ROUND(\n    IF(\n        L4>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M4,\n                L4 + CEILING((TIME(7,0,0)-L4)*24,1)/24\n            ) - L4\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M4<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M4 - MAX(\n                     L4 + CEILING((TIME(19,0,0)-L4)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":""},{"$f":"IF(OR(M4=\"\",L4=\"\",O4=\"\"),\"\",\n    ROUND((M4 - L4) * 1440 - O4, 10)\n)","v":""},{"$f":"IF(O4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O4,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":""},{"$f":"IF(P4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P4,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":""},{"$f":"IF(K4=\"\",R4,\"\")","v":""},{"$f":"IFERROR(IF(K4=\"\", \"\", R4),\"\")","v":""},{"$f":"IF(K4=\"\",Q4,IF(K4<>\"\",Q4))","v":""},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"ROW()-4","v":1},null,{"$f":"IF(C5=\"\",\"\",TEXT(C5,\"aaaa\"))","v":""},{"$f":"IFERROR(VLOOKUP(C5,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F5,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F5,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H5,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H5,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F5,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F5,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H5,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H5,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F5,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F5,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H5,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H5,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F5,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F5,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H5,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H5,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F5,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F5,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H5,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H5,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":""},{"$f":"IF(E5<>\"\",\"土日祝\",IF(OR(D5=\"土曜日\",D5=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F5,\"時\",\"\")), VALUE(SUBSTITUTE(G5,\"分\",\"\")), 0),\"\")","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H5,\"時\",\"\")),VALUE(SUBSTITUTE(I5,\"分\",\"\")),0),\"\")","v":""},{"$f":"IF(OR(M5=\"\",L5=\"\"),\"\", (M5 - L5) * 1440)","v":""},{"$f":"IFERROR(ROUND(\n    IF(\n        L5>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M5,\n                L5 + CEILING((TIME(7,0,0)-L5)*24,1)/24\n            ) - L5\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M5<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M5 - MAX(\n                     L5 + CEILING((TIME(19,0,0)-L5)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":""},{"$f":"IF(OR(M5=\"\",L5=\"\",O5=\"\"),\"\",\n    ROUND((M5 - L5) * 1440 - O5, 10)\n)","v":""},{"$f":"IF(O5=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O5,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":""},{"$f":"IF(P5=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P5,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":""},{"$f":"IF(K5=\"\",R5,\"\")","v":""},{"$f":"IFERROR(IF(K5=\"\", \"\", R5),\"\")","v":""},{"$f":"IF(K5=\"\",Q5,IF(K5<>\"\",Q5))","v":""}]

{"sheet":"集計用シート","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"","A 平日","B 土日祝　","C 時間外　"]
[null,"<1905/1/1",0,0,0]
[null,"総計",0,0,0]

{"sheet":"単月（あとでコピー)","index":3,"n_rows":60,"n_cols":31,"rows_kept":60,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,7,1,8],[0,5,0,6],[0,7,0,8]]}
[2026,null,"①要入力",null,null,"②要入力",null,"③要入力",null,"非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！",null,null,null,null,null,null,null,null,null,null,null,"0時","0分"]
[null,null,"日付","曜日","祝日","開始時刻",null,"終了時刻",null,"時間外判別","土日祝判定","開始時刻","終了時刻","全分数","時間外(m)","通常(m)","時間外(h)ベース","通常(h)ベース","A 平日\n(時間内)","B 土日祝","C 時間外",null,null,null,null,null,null,null,null,"1時","1分"]
[null,1,"2026-05-01",{"$f":"TEXT(C3,\"aaaa\")","v":"金曜日"},{"$f":"IFERROR(VLOOKUP(C3,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"4時","30分","9時","9分",{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":"②"},{"$f":"IF(E3<>\"\",\"土日祝\",IF(OR(D3=\"土曜日\",D3=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F3,\"時\",\"\")), VALUE(SUBSTITUTE(G3,\"分\",\"\")), 0),\"\")","v":"04:30:00"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H3,\"時\",\"\")),VALUE(SUBSTITUTE(I3,\"分\",\"\")),0),\"\")","v":"09:09:00"},{"$f":"IF(OR(M3=\"\",L3=\"\"),\"\", (M3 - L3) * 1440)","v":278.99999999999994},{"$f":"IFERROR(ROUND(\n    IF(\n        L3>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M3,\n                L3 + CEILING((TIME(7,0,0)-L3)*24,1)/24\n            ) - L3\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M3<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M3 - MAX(\n                     L3 + CEILING((TIME(19,0,0)-L3)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":180},{"$f":"IF(OR(M3=\"\",L3=\"\",O3=\"\"),\"\",\n    ROUND((M3 - L3) * 1440 - O3, 10)\n)","v":99},{"$f":"IF(O3=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O3,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":3},{"$f":"IF(P3=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P3,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":2},{"$f":"IF(K3=\"\",R3,\"\")","v":2},{"$f":"IFERROR(IF(K3=\"\", \"\", R3),\"\")","v":""},{"$f":"IF(K3=\"\",Q3,IF(K3<>\"\",Q3))","v":3},null,null,null,null,null,null,null,null,"2時","2分"]
[null,2,"2026-05-01",{"$f":"TEXT(C4,\"aaaa\")","v":"金曜日"},{"$f":"IFERROR(VLOOKUP(C4,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"8時","30分","19時","30分",{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":"③"},{"$f":"IF(E4<>\"\",\"土日祝\",IF(OR(D4=\"土曜日\",D4=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F4,\"時\",\"\")), VALUE(SUBSTITUTE(G4,\"分\",\"\")), 0),\"\")","v":"08:30:00"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H4,\"時\",\"\")),VALUE(SUBSTITUTE(I4,\"分\",\"\")),0),\"\")","v":"19:30:00"},{"$f":"IF(OR(M4=\"\",L4=\"\"),\"\", (M4 - L4) * 1440)","v":660},{"$f":"IFERROR(ROUND(\n    IF(\n        L4>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M4,\n                L4 + CEILING((TIME(7,0,0)-L4)*24,1)/24\n            ) - L4\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M4<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M4 - MAX(\n                     L4 + CEILING((TIME(19,0,0)-L4)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":0},{"$f":"IF(OR(M4=\"\",L4=\"\",O4=\"\"),\"\",\n    ROUND((M4 - L4) * 1440 - O4, 10)\n)","v":660},{"$f":"IF(O4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O4,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":0},{"$f":"IF(P4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P4,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":11},{"$f":"IF(K4=\"\",R4,\"\")","v":11},{"$f":"IFERROR(IF(K4=\"\", \"\", R4),\"\")","v":""},{"$f":"IF(K4=\"\",Q4,IF(K4<>\"\",Q4))","v":0},null,null,null,null,null,null,null,null,"3時","3分"]
[null,3,"2026-05-03","日曜日",{"$f":"IFERROR(VLOOKUP(C5,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"憲法記念日"},"5時","40分","7時","20分","②","土日祝","05:40:00","07:20:00",100.00000000000004,{"$f":"IFERROR(ROUND(\n    IF(\n        L5>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M5,\n                L5 + CEILING((TIME(7,0,0)-L5)*24,1)/24\n            ) - L5\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M5<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M5 - MAX(\n                     L5 + CEILING((TIME(19,0,0)-L5)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":100},{"$f":"IF(OR(M5=\"\",L5=\"\",O5=\"\"),\"\",\n    ROUND((M5 - L5) * 1440 - O5, 10)\n)","v":0},2,0,"",{"$f":"IFERROR(IF(K5=\"\", \"\", R5),\"\")","v":0},{"$f":"IF(K5=\"\",Q5,IF(K5<>\"\",Q5))","v":2},null,null,null,null,null,null,null,null,"4時","4分"]
[null,4,"2026-05-04","月曜日",{"$f":"IFERROR(VLOOKUP(C6,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"みどりの日"},"18時","0分","22時","31分","③","土日祝","18:00:00","22:31:00",271,211,{"$f":"IF(OR(M6=\"\",L6=\"\",O6=\"\"),\"\",\n    ROUND((M6 - L6) * 1440 - O6, 10)\n)","v":60},4,1,"",{"$f":"IFERROR(IF(K6=\"\", \"\", R6),\"\")","v":1},4,null,null,null,null,null,null,null,null,"5時","5分"]
[null,5,"2026-05-05","火曜日",{"$f":"IFERROR(VLOOKUP(C7,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"こどもの日"},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"6時","6分"]
[null,6,"2026-05-06","水曜日",{"$f":"IFERROR(VLOOKUP(C8,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"振替休日"},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"7時","7分"]
[null,7,"2026-05-07","木曜日",{"$f":"IFERROR(VLOOKUP(C9,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"18時","0分","22時","31分","③","","18:00:00","22:31:00",271,211,60,4,1,1,"",4,null,null,null,null,null,null,null,null,"8時","8分"]
[null,8,"2026-05-08","金曜日",{"$f":"IFERROR(VLOOKUP(C10,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"9時","9分"]
[null,9,"2026-05-09","土曜日",{"$f":"IFERROR(VLOOKUP(C11,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"10時","10分"]
[null,10,"2026-05-10","日曜日",{"$f":"IFERROR(VLOOKUP(C12,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"11時","11分"]
[null,11,"2026-05-11","月曜日",{"$f":"IFERROR(VLOOKUP(C13,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"12時","12分"]
[null,12,"2026-05-12","火曜日",{"$f":"IFERROR(VLOOKUP(C14,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"13時","13分"]
[null,13,"2026-05-13","水曜日",{"$f":"IFERROR(VLOOKUP(C15,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"14時","14分"]
[null,14,"2026-05-14","木曜日",{"$f":"IFERROR(VLOOKUP(C16,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"15時","15分"]
[null,15,"2026-05-15","金曜日",{"$f":"IFERROR(VLOOKUP(C17,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"16時","16分"]
[null,16,"2026-05-16","土曜日",{"$f":"IFERROR(VLOOKUP(C18,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"17時","17分"]
[null,17,"2026-05-17","日曜日",{"$f":"IFERROR(VLOOKUP(C19,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"18時","18分"]
[null,18,"2026-05-18","月曜日",{"$f":"IFERROR(VLOOKUP(C20,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"19時","19分"]
[null,19,"2026-05-19","火曜日",{"$f":"IFERROR(VLOOKUP(C21,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"20時","20分"]
[null,20,"2026-05-20","水曜日",{"$f":"IFERROR(VLOOKUP(C22,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"21時","21分"]
[null,21,"2026-05-21","木曜日",{"$f":"IFERROR(VLOOKUP(C23,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"22時","22分"]
[null,22,"2026-05-22","金曜日",{"$f":"IFERROR(VLOOKUP(C24,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"23時","23分"]
[null,23,"2026-05-23","土曜日",{"$f":"IFERROR(VLOOKUP(C25,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"24分"]
[null,24,"2026-05-24","日曜日",{"$f":"IFERROR(VLOOKUP(C26,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"25分"]
[null,25,"2026-05-25","月曜日",{"$f":"IFERROR(VLOOKUP(C27,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"26分"]
[null,26,"2026-05-26","火曜日",{"$f":"IFERROR(VLOOKUP(C28,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"27分"]
[null,27,"2026-05-27","水曜日",{"$f":"IFERROR(VLOOKUP(C29,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"28分"]
[null,28,"2026-05-28","木曜日",{"$f":"IFERROR(VLOOKUP(C30,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"29分"]
[null,29,"2026-05-29","金曜日",{"$f":"IFERROR(VLOOKUP(C31,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"30分"]
[null,30,"2026-05-30","土曜日",{"$f":"IFERROR(VLOOKUP(C32,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"31分"]
[null,31,"2026-05-31","日曜日",{"$f":"IFERROR(VLOOKUP(C33,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","",{"$f":"IF(K33=\"\",Q33,IF(K33<>\"\",R33))","v":""},null,null,null,null,null,null,null,null,null,"32分"]
[null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S33)","v":14},{"$f":"SUM(T3:T33)","v":1},{"$f":"SUM(U3:U33)","v":13},null,null,null,null,null,null,null,null,null,"33分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"49分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"53分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"56分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"57分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"58分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"59分"]

{"sheet":"単月（あとで月数分コピー）","index":4,"n_rows":55,"n_cols":31,"rows_kept":55,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,7,1,8]]}
[2026,null,null,null,null,null,null,null,null,"非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！",null,null,null,null,null,null,null,null,null,null,null,"0時","0分"]
[null,null,"日付","曜日","祝日","開始時刻",null,"終了時刻",null,"時間外判別","土日祝判定","開始時刻","終了時刻","全分数","時間外(m)","通常(m)","時間外(h)ベース","通常(h)ベース","A 平日\n(時間内)","B 土日祝","C 時間外",null,null,null,null,null,null,null,null,"1時","1分"]
[null,1,"2026-05-01",{"$f":"TEXT(C3,\"aaaa\")","v":"金曜日"},{"$f":"IFERROR(VLOOKUP(C3,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"17時","30分","21時","0分",{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":"③"},{"$f":"IF(E3<>\"\",\"土日祝\",IF(OR(D3=\"土曜日\",D3=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F3,\"時\",\"\")), VALUE(SUBSTITUTE(G3,\"分\",\"\")), 0),\"\")","v":"17:30:00"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H3,\"時\",\"\")),VALUE(SUBSTITUTE(I3,\"分\",\"\")),0),\"\")","v":"21:00:00"},{"$f":"IF(OR(M3=\"\",L3=\"\"),\"\", (M3 - L3) * 1440)","v":210.00000000000006},{"$f":"IFERROR(ROUND(\n    IF(\n        L3>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M3,\n                L3 + CEILING((TIME(7,0,0)-L3)*24,1)/24\n            ) - L3\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M3<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M3 - MAX(\n                     L3 + CEILING((TIME(19,0,0)-L3)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":90},{"$f":"IF(OR(M3=\"\",L3=\"\",O3=\"\"),\"\",\n    ROUND((M3 - L3) * 1440 - O3, 10)\n)","v":120},{"$f":"IF(O3=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O3,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":1.5},{"$f":"IF(P3=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P3,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":2},{"$f":"IF(K3=\"\",R3,\"\")","v":2},{"$f":"IFERROR(IF(K3=\"\", \"\", R3),\"\")","v":""},{"$f":"IF(K3=\"\",Q3,IF(K3<>\"\",Q3))","v":1.5},null,null,null,null,null,null,null,null,"2時","2分"]
[null,2,"2026-05-02",{"$f":"TEXT(C4,\"aaaa\")","v":"土曜日"},{"$f":"IFERROR(VLOOKUP(C4,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"17時","30分","21時","0分",{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":"③"},{"$f":"IF(E4<>\"\",\"土日祝\",IF(OR(D4=\"土曜日\",D4=\"日曜日\"),\"土日祝\",\"\"))","v":"土日祝"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F4,\"時\",\"\")), VALUE(SUBSTITUTE(G4,\"分\",\"\")), 0),\"\")","v":"17:30:00"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H4,\"時\",\"\")),VALUE(SUBSTITUTE(I4,\"分\",\"\")),0),\"\")","v":"21:00:00"},{"$f":"IF(OR(M4=\"\",L4=\"\"),\"\", (M4 - L4) * 1440)","v":210.00000000000006},{"$f":"IFERROR(ROUND(\n    IF(\n        L4>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M4,\n                L4 + CEILING((TIME(7,0,0)-L4)*24,1)/24\n            ) - L4\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M4<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M4 - MAX(\n                     L4 + CEILING((TIME(19,0,0)-L4)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":90},{"$f":"IF(OR(M4=\"\",L4=\"\",O4=\"\"),\"\",\n    ROUND((M4 - L4) * 1440 - O4, 10)\n)","v":120},{"$f":"IF(O4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O4,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":1.5},{"$f":"IF(P4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P4,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":2},{"$f":"IF(K4=\"\",R4,\"\")","v":""},{"$f":"IFERROR(IF(K4=\"\", \"\", R4),\"\")","v":2},{"$f":"IF(K4=\"\",Q4,IF(K4<>\"\",Q4))","v":1.5},null,null,null,null,null,null,null,null,"3時","3分"]
[null,3,"2026-05-03","日曜日",{"$f":"IFERROR(VLOOKUP(C5,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"憲法記念日"},"5時","40分","7時","20分","②","土日祝","05:40:00","07:20:00",100.00000000000004,{"$f":"IFERROR(ROUND(\n    IF(\n        L5>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M5,\n                L5 + CEILING((TIME(7,0,0)-L5)*24,1)/24\n            ) - L5\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M5<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M5 - MAX(\n                     L5 + CEILING((TIME(19,0,0)-L5)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":100},{"$f":"IF(OR(M5=\"\",L5=\"\",O5=\"\"),\"\",\n    ROUND((M5 - L5) * 1440 - O5, 10)\n)","v":0},2,0,"",{"$f":"IFERROR(IF(K5=\"\", \"\", R5),\"\")","v":0},{"$f":"IF(K5=\"\",Q5,IF(K5<>\"\",Q5))","v":2},null,null,null,null,null,null,null,null,"4時","4分"]
[null,4,"2026-05-04","月曜日",{"$f":"IFERROR(VLOOKUP(C6,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"みどりの日"},null,null,null,null,"","土日祝","","","","",{"$f":"IF(OR(M6=\"\",L6=\"\",O6=\"\"),\"\",\n    ROUND((M6 - L6) * 1440 - O6, 10)\n)","v":""},"","","","","",null,null,null,null,null,null,null,null,"5時","5分"]
[null,5,"2026-05-05","火曜日",{"$f":"IFERROR(VLOOKUP(C7,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"こどもの日"},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"6時","6分"]
[null,6,"2026-05-06",{"$f":"TEXT(C8,\"aaaa\")","v":"水曜日"},{"$f":"IFERROR(VLOOKUP(C8,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"振替休日"},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"7時","7分"]
[null,7,"2026-05-07","木曜日",{"$f":"IFERROR(VLOOKUP(C9,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"5時","40分","7時","20分","②","","05:40:00","07:20:00",100.00000000000004,100,0,2,0,0,"",2,null,null,null,null,null,null,null,null,"8時","8分"]
[null,8,"2026-05-08","金曜日",{"$f":"IFERROR(VLOOKUP(C10,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"9時","9分"]
[null,9,"2026-05-09","土曜日",{"$f":"IFERROR(VLOOKUP(C11,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"10時","10分"]
[null,10,"2026-05-10","日曜日",{"$f":"IFERROR(VLOOKUP(C12,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"6時","40分","8時","0分","②","土日祝","06:40:00","08:00:00",79.999999999999957,60,20,1,0.5,"",0.5,1,null,null,null,null,null,null,null,null,"11時","11分"]
[null,11,"2026-05-11","月曜日",{"$f":"IFERROR(VLOOKUP(C13,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"6時","40分","8時","0分","②","","06:40:00","08:00:00",79.999999999999957,60,20,1,0.5,0.5,"",1,null,null,null,null,null,null,null,null,"12時","12分"]
[null,12,"2026-05-12","火曜日",{"$f":"IFERROR(VLOOKUP(C14,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"13時","13分"]
[null,13,"2026-05-13","水曜日",{"$f":"IFERROR(VLOOKUP(C15,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"14時","14分"]
[null,14,"2026-05-14","木曜日",{"$f":"IFERROR(VLOOKUP(C16,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"15時","15分"]
[null,15,"2026-05-15","金曜日",{"$f":"IFERROR(VLOOKUP(C17,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"16時","16分"]
[null,16,"2026-05-16","土曜日",{"$f":"IFERROR(VLOOKUP(C18,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"17時","17分"]
[null,17,"2026-05-17",{"$f":"TEXT(C19,\"aaaa\")","v":"日曜日"},{"$f":"IFERROR(VLOOKUP(C19,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,"18時","18分"]
[null,18,"2026-05-18","月曜日",{"$f":"IFERROR(VLOOKUP(C20,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"19時","19分"]
[null,19,"2026-05-19","火曜日",{"$f":"IFERROR(VLOOKUP(C21,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"20時","20分"]
[null,20,"2026-05-20","水曜日",{"$f":"IFERROR(VLOOKUP(C22,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"21時","21分"]
[null,21,"2026-05-21",{"$f":"TEXT(C23,\"aaaa\")","v":"木曜日"},{"$f":"IFERROR(VLOOKUP(C23,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"22時","22分"]
[null,22,"2026-05-22","金曜日",{"$f":"IFERROR(VLOOKUP(C24,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,"23時","23分"]
[null,23,"2026-05-23","土曜日",{"$f":"IFERROR(VLOOKUP(C25,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"24分"]
[null,24,"2026-05-24","日曜日",{"$f":"IFERROR(VLOOKUP(C26,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"25分"]
[null,25,"2026-05-25","月曜日",{"$f":"IFERROR(VLOOKUP(C27,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"26分"]
[null,26,"2026-05-26","火曜日",{"$f":"IFERROR(VLOOKUP(C28,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"27分"]
[null,27,"2026-05-27","水曜日",{"$f":"IFERROR(VLOOKUP(C29,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"28分"]
[null,28,"2026-05-28","木曜日",{"$f":"IFERROR(VLOOKUP(C30,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"29分"]
[null,29,"2026-05-29","金曜日",{"$f":"IFERROR(VLOOKUP(C31,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"30分"]
[null,30,"2026-05-30","土曜日",{"$f":"IFERROR(VLOOKUP(C32,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"31分"]
[null,31,"2026-05-31","日曜日",{"$f":"IFERROR(VLOOKUP(C33,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},null,null,null,null,"","土日祝","","","","","","","","","",{"$f":"IF(K33=\"\",Q33,IF(K33<>\"\",R33))","v":""},null,null,null,null,null,null,null,null,null,"32分"]
[null,"合計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S3:S33)","v":2.5},{"$f":"SUM(T3:T33)","v":2.5},{"$f":"SUM(U3:U33)","v":9},null,null,null,null,null,null,null,null,null,"33分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"49分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"53分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54分"]

{"sheet":"テスト","index":5,"n_rows":61,"n_cols":31,"rows_kept":61,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,7,1,8]]}
[2026,null,null,null,null,null,null,null,null,null,null,"数式",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0時","0分"]
[null,null,"日付","曜日","祝日","開始時刻",null,"終了時刻",null,"時間外判別PTN","土日祝日判定","開始時刻","終了時刻","全体の分数","時間外枠(分)","通常枠(分)","時間外（時間）","通常（時間）",null,null,null,null,null,null,null,null,null,null,null,"1時","1分"]
[null,1,"2026-07-09",{"$f":"TEXT(C3,\"aaaa\")","v":"木曜日"},{"$f":"IFERROR(VLOOKUP(C3,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"6時","0分","6時","14分",{"$f":"IF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F3,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H3,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H3,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\")))))","v":"⑤"},{"$f":"IF(E3<>\"\",\"土日祝\",IF(OR(D2=\"土曜日\",D2=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"TIME(VALUE(SUBSTITUTE(F3,\"時\",\"\")), VALUE(SUBSTITUTE(G3,\"分\",\"\")), 0)","v":"06:00:00"},{"$f":"TIME(VALUE(SUBSTITUTE(H3,\"時\",\"\")), VALUE(SUBSTITUTE(I3,\"分\",\"\")), 0)","v":"06:14:00"},{"$f":"(M3 - L3) * 1440","v":14.00000000000003},{"$f":"IF(\n    L3>=TIME(7,0,0),\n    0,\n    MAX(\n        0,\n        (MIN(\n            M3,\n            L3 + CEILING((TIME(7,0,0)-L3)*24,1)/24\n        ) - L3\n        ) * 1440\n    )\n)\n+\nIF(\n    M3<=TIME(19,0,0),\n    0,\n    MAX(\n        0,\n        (M3 - MAX(\n                 L3 + CEILING((TIME(19,0,0)-L3)*24,1)/24,\n                 TIME(19,0,0)\n             )\n        ) * 1440\n    )\n)","v":14.00000000000003},{"$f":"(M3 - L3) * 1440 - O3","v":0},{"$f":"_xlfn.LET(\n    _xlpm.m, ROUND(O3,0),\n    _xlpm.h, QUOTIENT(_xlpm.m,60),\n    _xlpm.r, MOD(_xlpm.m,60),\n    _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n)","v":0.5},{"$f":"_xlfn.LET(\n    _xlpm.m, ROUND(P3,0),\n    INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n)","v":0},null,null,null,null,null,null,null,null,null,null,null,"2時","2分"]
[null,2,"2026-07-20",{"$f":"TEXT(C4,\"aaaa\")","v":"月曜日"},{"$f":"IFERROR(VLOOKUP(C4,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":"海の日"},"17時","30分","21時","0分",{"$f":"IF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\")))))","v":"③"},{"$f":"IF(E4<>\"\",\"土日祝\",IF(OR(D3=\"土曜日\",D3=\"日曜日\"),\"土日祝\",\"\"))","v":"土日祝"},{"$f":"TIME(VALUE(SUBSTITUTE(F4,\"時\",\"\")), VALUE(SUBSTITUTE(G4,\"分\",\"\")), 0)","v":"17:30:00"},{"$f":"TIME(VALUE(SUBSTITUTE(H4,\"時\",\"\")), VALUE(SUBSTITUTE(I4,\"分\",\"\")), 0)","v":"21:00:00"},{"$f":"(M4 - L4) * 1440","v":210.00000000000006},{"$f":"IF(\n    L4>=TIME(7,0,0),\n    0,\n    MAX(\n        0,\n        (MIN(\n            M4,\n            L4 + CEILING((TIME(7,0,0)-L4)*24,1)/24\n        ) - L4\n        ) * 1440\n    )\n)\n+\nIF(\n    M4<=TIME(19,0,0),\n    0,\n    MAX(\n        0,\n        (M4 - MAX(\n                 L4 + CEILING((TIME(19,0,0)-L4)*24,1)/24,\n                 TIME(19,0,0)\n             )\n        ) * 1440\n    )\n)","v":90},{"$f":"(M4 - L4) * 1440 - O4","v":120.00000000000006},{"$f":"_xlfn.LET(\n    _xlpm.m, ROUND(O4,0),\n    _xlpm.h, QUOTIENT(_xlpm.m,60),\n    _xlpm.r, MOD(_xlpm.m,60),\n    _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n)","v":1.5},{"$f":"_xlfn.LET(\n    _xlpm.m, ROUND(P4,0),\n    INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n)","v":2},null,null,null,null,null,null,null,null,null,null,null,"3時","3分"]
[null,3,"2026-07-11","土曜日",{"$f":"IFERROR(VLOOKUP(C5,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"5時","40分","7時","20分","②",{"$f":"IF(E5<>\"\",\"土日祝\",IF(OR(D4=\"土曜日\",D4=\"日曜日\"),\"土日祝\",\"\"))","v":""},{"$f":"TIME(VALUE(SUBSTITUTE(F5,\"時\",\"\")), VALUE(SUBSTITUTE(G5,\"分\",\"\")), 0)","v":"05:40:00"},{"$f":"TIME(VALUE(SUBSTITUTE(H5,\"時\",\"\")), VALUE(SUBSTITUTE(I5,\"分\",\"\")), 0)","v":"07:20:00"},100.00000000000004,100.00000000000004,0,2,0,null,null,null,null,null,null,null,null,null,null,null,"4時","4分"]
[null,4,"2026-07-12","日曜日",{"$f":"IFERROR(VLOOKUP(C6,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"18時","50分","20時","30分",{"$f":"IF(AND(VALUE(SUBSTITUTE(F6,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F6,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H6,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H6,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F6,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F6,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H6,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H6,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F6,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F6,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H6,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H6,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F6,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F6,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H6,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H6,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F6,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F6,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H6,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H6,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\")))))","v":"③"},{"$f":"IF(E6<>\"\",\"土日祝\",IF(OR(D5=\"土曜日\",D5=\"日曜日\"),\"土日祝\",\"\"))","v":"土日祝"},{"$f":"TIME(VALUE(SUBSTITUTE(F6,\"時\",\"\")), VALUE(SUBSTITUTE(G6,\"分\",\"\")), 0)","v":"18:50:00"},{"$f":"TIME(VALUE(SUBSTITUTE(H6,\"時\",\"\")), VALUE(SUBSTITUTE(I6,\"分\",\"\")), 0)","v":"20:30:00"},99.999999999999972,40.000000000000014,59.999999999999957,1,1,null,null,null,null,null,null,null,null,null,null,null,"5時","5分"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7時","7分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8時","8分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9時","9分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10時","10分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11時","11分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12時","12分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13時","13分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14時","14分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15時","15分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16時","16分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17時","17分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18時","18分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19時","19分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20時","20分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21時","21分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22時","22分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23時","23分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24時","24分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"26分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"34分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"35分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"36分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"42分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"43分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"49分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"53分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"56分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"57分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"58分"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"59分"]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"祝日判定マスタ","index":7,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["2026-01-01","元日",null,null,null,"0時","0分"]
["2026-01-12","成人の日",null,null,null,"1時","1分"]
["2026-02-11","建国記念の日",null,null,null,"2時","2分"]
["2026-02-23","天皇誕生日",null,null,null,"3時","3分"]
["2026-03-20","春分の日",null,null,null,"4時","4分"]
["2026-04-29","昭和の日",null,null,null,"5時","5分"]
["2026-05-03","憲法記念日",null,null,null,"6時","6分"]
["2026-05-04","みどりの日",null,null,null,"7時","7分"]
["2026-05-05","こどもの日",null,null,null,"8時","8分"]
["2026-05-06","振替休日","祝日法第3条第2項による休日",null,null,"9時","9分"]
["2026-07-20","海の日",null,null,null,"10時","10分"]
["2026-08-11","山の日",null,null,null,"11時","11分"]
["2026-09-21","敬老の日",null,null,null,"12時","12分"]
["2026-09-22","国民の休日","祝日法第3条第3項による休日",null,null,"13時","13分"]
["2026-09-23","秋分の日",null,null,null,"14時","14分"]
["2026-10-12"," スポーツの日",null,null,null,"15時","15分"]
["2026-11-03","文化の日",null,null,null,"16時","16分"]
["2026-11-23","勤労感謝の日",null,null,null,"17時","17分"]
["2027-01-01","元日",null,null,null,"18時","18分"]
["2027-01-11","成人の日",null,null,null,"19時","19分"]
["2027-02-11","建国記念の日",null,null,null,"20時","20分"]
["2027-02-23","天皇誕生日",null,null,null,"21時","21分"]
["2027-03-21","春分の日",null,null,null,"22時","22分"]
["2027-03-22","振替休日","祝日法第3条第2項による休日",null,null,"23時","23分"]
["2027-04-29","昭和の日",null,null,null,null,"24分"]
["2027-05-03","憲法記念日",null,null,null,null,"25分"]
["2027-05-04","みどりの日",null,null,null,null,"26分"]
["2027-05-05","こどもの日",null,null,null,null,"27分"]
["2027-07-19","海の日",null,null,null,null,"28分"]
["2027-08-11","山の日",null,null,null,null,"29分"]
["2027-09-20","敬老の日",null,null,null,null,"30分"]
["2027-09-23","秋分の日",null,null,null,null,"31分"]
["2027-10-11","スポーツの日",null,null,null,null,"32分"]
["2027-11-03","文化の日",null,null,null,null,"33分"]
["2027-11-23","勤労感謝の日",null,null,null,null,"34分"]
[null,null,null,null,null,null,"35分"]
[null,null,null,null,null,null,"36分"]
[null,null,null,null,null,null,"37分"]
[null,null,null,null,null,null,"38分"]
[null,null,null,null,null,null,"39分"]
[null,null,null,null,null,null,"40分"]
[null,null,null,null,null,null,"41分"]
[null,null,null,null,null,null,"42分"]
[null,null,null,null,null,null,"43分"]
[null,null,null,null,null,null,"44分"]
[null,null,null,null,null,null,"45分"]
[null,null,null,null,null,null,"46分"]
[null,null,null,null,null,null,"47分"]
[null,null,null,null,null,null,"48分"]
[null,null,null,null,null,null,"49分"]
[null,null,null,null,null,null,"50分"]
[null,null,null,null,null,null,"51分"]
[null,null,null,null,null,null,"52分"]
[null,null,null,null,null,null,"53分"]
[null,null,null,null,null,null,"54分"]
[null,null,null,null,null,null,"55分"]
[null,null,null,null,null,null,"56分"]
[null,null,null,null,null,null,"57分"]
[null,null,null,null,null,null,"58分"]
[null,null,null,null,null,null,"59分"]

{"sheet":"単月(いじる用） (✕✕✕)","index":8,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,7,1,8]]}
[]
[null,null,"①要入力",null,null,"②要入力",null,"③要入力",null,"非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！","非表示！"]
[null,"No","日付","曜日","祝日","               開始時刻",null,"                  終了時刻",null,"時間外判別","土日祝判定","開始時刻","終了時刻","全分数","時間外(m)","通常(m)","時間外(h)ベース","通常(h)ベース","A 平日\n(時間内)","B 土日祝","C 時間外",null,"A 平日\n(時間内)","B 土日祝","C 時間外"]
[null,"例","（例）1月１日","木曜日","元日","9時","0分","12時","0分",{"$f":"IFERROR(IF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"①\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=18),\n    \"②\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=7, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=18,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"③\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=24,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=19, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=24),\n    \"④\",\nIF(AND(VALUE(SUBSTITUTE(F4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(F4,\"時\",\"\"))<=6,\n        VALUE(SUBSTITUTE(H4,\"時\",\"\"))>=0, VALUE(SUBSTITUTE(H4,\"時\",\"\"))<=6),\n    \"⑤\",\n\"\"))))),\"\")","v":"①"},{"$f":"IF(E4<>\"\",\"土日祝\",IF(OR(D4=\"土曜日\",D4=\"日曜日\"),\"土日祝\",\"\"))","v":"土日祝"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(F4,\"時\",\"\")), VALUE(SUBSTITUTE(G4,\"分\",\"\")), 0),\"\")","v":"09:00:00"},{"$f":"IFERROR(TIME(VALUE(SUBSTITUTE(H4,\"時\",\"\")),VALUE(SUBSTITUTE(I4,\"分\",\"\")),0),\"\")","v":"12:00:00"},{"$f":"IF(OR(M4=\"\",L4=\"\"),\"\", (M4 - L4) * 1440)","v":180},{"$f":"IFERROR(ROUND(\n    IF(\n        L4>=TIME(7,0,0),\n        0,\n        MAX(\n            0,\n            (MIN(\n                M4,\n                L4 + CEILING((TIME(7,0,0)-L4)*24,1)/24\n            ) - L4\n            ) * 1440\n        )\n    )\n    +\n    IF(\n        M4<=TIME(19,0,0),\n        0,\n        MAX(\n            0,\n            (M4 - MAX(\n                     L4 + CEILING((TIME(19,0,0)-L4)*24,1)/24,\n                     TIME(19,0,0)\n                 )\n            ) * 1440\n        )\n    ), 10),\"\")","v":0},{"$f":"IF(OR(M4=\"\",L4=\"\",O4=\"\"),\"\",\n    ROUND((M4 - L4) * 1440 - O4, 10)\n)","v":180},{"$f":"IF(O4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(O4,0),\n        _xlpm.h, QUOTIENT(_xlpm.m,60),\n        _xlpm.r, MOD(_xlpm.m,60),\n        _xlpm.h + IF(_xlpm.r=0,0,IF(_xlpm.r<=30,0.5,1))\n    )\n)","v":0},{"$f":"IF(P4=\"\",\"\",\n    _xlfn.LET(\n        _xlpm.m, ROUND(P4,0),\n        INT(_xlpm.m/60) + IF(MOD(_xlpm.m,60)=0,0,IF(MOD(_xlpm.m,60)<=30,0.5,1))\n    )\n)","v":3},{"$f":"IF(K4=\"\",R4,\"\")","v":""},{"$f":"IFERROR(IF(K4=\"\", \"\", R4),\"\")","v":3},null,null,{"$f":"SUM(S5:S108)","v":16.5},{"$f":"SUM(T5:T108)","v":0},{"$f":"SUM(U5:U108)","v":0}]
[null,{"$f":"ROW()-4","v":1},"2026-08-03",{"$f":"IF(C5=\"\",\"\",TEXT(C5,\"aaaa\"))","v":"月曜日"},{"$f":"IFERROR(VLOOKUP(C5,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"9時","1分","13時","1分","①","","09:01:00","13:01:00",239.99999999999994,0,240,0,4,4,"",{"$f":"IF(K5=\"\",Q5,IF(K5<>\"\",Q5))","v":0}]
[null,{"$f":"ROW()-4","v":2},"2026-08-18","火曜日",{"$f":"IFERROR(VLOOKUP(C6,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"9時","2分","14時","2分","①","","09:02:00","14:02:00",300.00000000000006,0,300,0,5,5,"",0]
[null,{"$f":"ROW()-4","v":3},"2026-09-14","月曜日",{"$f":"IFERROR(VLOOKUP(C7,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"9時","3分","15時","3分","①","","09:03:00","15:03:00",360,0,360,0,6,6,"",0]
[null,{"$f":"ROW()-4","v":4},"2026-08-28","金曜日",{"$f":"IFERROR(VLOOKUP(C8,祝日判定マスタ!$A:$B,2,FALSE),\"\")","v":""},"17時","1分","18時","6分","①","","17:01:00","18:06:00",64.999999999999929,0,65,0,1.5,1.5,"",0]