{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["8 Diligências","16 Diligências","24 Diligências","52 Diligências"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"8 Diligências","index":0,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,8,20,10],[24,8,24,9],[6,1,9,1],[6,17,9,17],[13,17,16,17],[13,1,16,1],[6,2,7,4],[6,6,7,8],[6,10,7,12],[6,14,7,16],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[11,14,11,16],[11,6,11,8],[11,2,11,4],[18,14,18,16],[15,3,15,4],[15,7,15,8],[15,11,15,12],[15,15,15,16],[13,5,16,5],[13,2,14,4],[13,6,14,8],[13,9,16,9],[13,10,14,12],[13,13,16,13],[13,14,14,16],[5,2,5,3],[6,5,9,5],[18,2,18,4],[18,6,18,8],[18,10,18,12],[23,5,25,7],[23,11,25,15],[23,3,25,4],[21,5,22,7],[21,3,22,4],[21,8,21,10],[2,19,2,20],[5,15,5,16],[5,12,5,14],[4,5,4,6],[20,11,22,15],[20,3,20,7],[2,2,2,16],[4,15,4,16],[4,2,4,4],[4,12,4,14],[4,7,4,11],[11,10,11,12],[6,13,9,13],[6,9,9,9],[3,2,3,3],[3,4,3,5]]}
[]
[]
[null,null,"Cálculo das horas das diligências\n(cfr. n.º 1 do artigo 5.º da Portaria 1386/2004, de 10 de novembro,\n com as alterações introduzidas pelo artigo 2.º da Portaria 26/2025/1, de 3 de fevereiro)"]
[null,null,{"$f":"IF(F5>0,\" \",\"Verifique Valor\")","v":" "},null,null,null,null,null,null,{"$f":"ISNUMBER(F5)","v":false}]
[null,null,"Nome do(a) Patrono(a):",null,null,"Dr(a) ",null,null,null,null,null,null,"Data da nomeação:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor da hora:",null,null,22]
[null,null,"1ª Sessão",null,null,null,"2ª Sessão",null,null,null,"3ª Sessão",null,null,null,"4ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D11-C11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H11-G11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L11-K11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P11-O11","v":"00:00:00"}]
[null,null,{"$f":"IF(D11<C11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H11<G11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L11<K11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P11<O11,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"5ª Sessão",null,null,null,"6ª Sessão",null,null,null,"7ªSessão",null,null,null,"8ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D18-C18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H18-G18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L18-K18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P18-O18","v":"00:00:00"}]
[null,null,{"$f":"IF(D18<C18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H18<G18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L18<K18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P18<O18,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,null,"Total de horas das Diligências",null,null,null,null,"Arredondamento das horas",null,null,"Montante total a liquidar "]
[null,null,null,"Soma das sessões em horas e minutos",null,"Com arredondamento em dias e horas",null,null,{"$f":"CEILING(D24, \"1:00\")","v":"00:00:00"}]
[]
[null,null,null,{"$f":"(E11+I11+M11+Q11+E18+I18+M18+Q18)","v":0},null,{"$f":"CONCATENATE(I26,\" Dia(s) e \",TEXT(K26,\"HH:MM\"),\" Horas\")","v":"0 Dia(s) e 00:00 Horas"},null,null,null,null,null,{"$f":"I22*24*P6","v":0}]
[null,null,null,null,null,null,null,null,"Dias Inteiros",null,"Horas"]
[null,null,null,null,null,null,null,null,{"$f":"INT(I22)","v":0},null,{"$f":"I22-I26","v":0},null,null,null,null,null,"v. 1.2026.05.22"]

{"sheet":"16 Diligências","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,2,2,16],[3,2,3,3],[3,4,3,5],[4,2,4,4],[4,15,4,16],[4,5,4,6],[4,7,4,11],[4,12,4,14],[5,2,5,3],[6,1,9,1],[6,2,7,4],[6,5,9,5],[6,6,7,8],[6,10,7,12],[6,13,9,13],[6,14,7,16],[6,17,9,17],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[6,9,9,9],[11,2,11,4],[11,6,11,8],[11,10,11,12],[11,14,11,16],[13,1,16,1],[13,2,14,4],[13,5,16,5],[13,6,14,8],[13,9,16,9],[13,10,14,12],[13,13,16,13],[13,14,14,16],[13,17,16,17],[15,3,15,4],[15,7,15,8],[15,11,15,12],[15,15,15,16],[32,10,32,12],[32,14,32,16],[37,3,39,4],[37,5,39,7],[19,2,19,3],[20,13,23,13],[20,14,21,16],[27,13,30,13],[37,11,39,15],[34,8,34,10],[35,8,35,10],[38,8,38,9],[20,1,23,1],[20,2,21,4],[20,5,23,5],[20,6,21,8],[20,9,23,9],[20,17,23,17],[22,3,22,4],[22,7,22,8],[22,11,22,12],[22,15,22,16],[20,10,21,12],[27,1,30,1],[27,2,28,4],[27,5,30,5],[27,6,28,8],[27,9,30,9],[27,17,30,17],[29,3,29,4],[29,7,29,8],[29,11,29,12],[29,15,29,16],[27,10,28,12],[27,14,28,16],[5,12,5,14],[5,15,5,16],[34,3,34,7],[34,11,36,15],[35,3,36,4],[35,5,36,7],[18,2,18,4],[18,6,18,8],[18,10,18,12],[18,14,18,16],[25,2,25,4],[25,6,25,8],[25,10,25,12],[25,14,25,16],[32,2,32,4],[32,6,32,8]]}
[]
[]
[null,null,"Cálculo das horas das diligências\n(cfr. n.º 1 do artigo 5.º da Portaria 1386/2004, de 10 de novembro,\n com as alterações introduzidas pelo artigo 2.º da Portaria 26/2025/1, de 3 de fevereiro)"]
[null,null,{"$f":"IF(F5>0,\" \",\"Verifique Valor\")","v":" "},null,null,null,null,null,null,{"$f":"ISNUMBER(F5)","v":false}]
[null,null,"Nome do(a) Patrono(a):",null,null,"Dr(a) ",null,null,null,null,null,null,"Data da nomeação:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor da hora:",null,null,22]
[null,null,"1ª Sessão",null,null,null,"2ª Sessão",null,null,null,"3ª Sessão",null,null,null,"4ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D11-C11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H11-G11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L11-K11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P11-O11","v":"00:00:00"}]
[null,null,{"$f":"IF(D11<C11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H11<G11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L11<K11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P11<O11,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"5ª Sessão",null,null,null,"6ª Sessão",null,null,null,"7ªSessão",null,null,null,"8ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D18-C18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H18-G18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L18-K18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P18-O18","v":"00:00:00"}]
[null,null,{"$f":"IF(D18<C18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H18<G18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L18<K18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P18<O18,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"9ª Sessão",null,null,null,"10ª Sessão",null,null,null,"11ª Sessão",null,null,null,"12ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D25-C25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H25-G25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L25-K25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P25-O25","v":"00:00:00"}]
[null,null,{"$f":"IF(D25<C25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H25<G25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L25<K25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P25<O25,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"13ª Sessão",null,null,null,"14ª Sessão",null,null,null,"15ª Sessão",null,null,null,"16ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D32-C32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H32-G32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L32-K32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P32-O32","v":"00:00:00"}]
[null,null,{"$f":"IF(D32<C32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H32<G32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L32<K32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P32<O32,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,null,"Total de horas das Diligências",null,null,null,null,"Arredondamento das horas",null,null,"Montante total a liquidar "]
[null,null,null,"Soma das sessões em horas e minutos",null,"Com arredondamento em dias e horas",null,null,{"$f":"CEILING(D38, \"1:00\")","v":"00:00:00"}]
[]
[null,null,null,{"$f":"(E11+I11+M11+Q11+E18+I18+M18+Q18+E25+I25+M25+Q25+E32+I32+M32+Q32)","v":0},null,{"$f":"CONCATENATE(I40,\" Dia(s) e \",TEXT(K40,\"HH:MM\"),\" Horas\")","v":"0 Dia(s) e 00:00 Horas"},null,null,null,null,null,{"$f":"I36*24*$P$6","v":0}]
[null,null,null,null,null,null,null,null,"Dias Inteiros",null,"Horas"]
[null,null,null,null,null,null,null,null,{"$f":"INT(I36)","v":0},null,{"$f":"I36-I40","v":0},null,null,null,null,null,"v. 1.2026.05.22"]

{"sheet":"24 Diligências","index":2,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,2,2,16],[3,2,3,3],[3,4,3,5],[4,2,4,4],[4,15,4,16],[5,2,5,3],[6,1,9,1],[6,2,7,4],[6,5,9,5],[6,6,7,8],[6,10,7,12],[6,13,9,13],[6,14,7,16],[4,5,4,6],[4,7,4,11],[4,12,4,14],[5,12,5,14],[5,15,5,16],[13,17,16,17],[15,3,15,4],[15,7,15,8],[15,11,15,12],[15,15,15,16],[6,17,9,17],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[6,9,9,9],[11,2,11,4],[11,6,11,8],[11,10,11,12],[11,14,11,16],[18,2,18,4],[18,6,18,8],[18,10,18,12],[18,14,18,16],[19,2,19,3],[20,10,21,12],[20,13,23,13],[20,14,21,16],[13,1,16,1],[13,2,14,4],[13,5,16,5],[13,6,14,8],[13,9,16,9],[13,10,14,12],[13,13,16,13],[13,14,14,16],[34,1,37,1],[27,17,30,17],[29,3,29,4],[29,7,29,8],[29,11,29,12],[29,15,29,16],[20,17,23,17],[22,3,22,4],[22,7,22,8],[22,11,22,12],[22,15,22,16],[25,2,25,4],[25,6,25,8],[25,10,25,12],[25,14,25,16],[27,13,30,13],[27,14,28,16],[20,1,23,1],[20,2,21,4],[20,5,23,5],[20,6,21,8],[20,9,23,9],[27,1,30,1],[41,14,42,16],[51,11,53,15],[27,2,28,4],[27,5,30,5],[27,6,28,8],[27,9,30,9],[27,10,28,12],[46,2,46,4],[32,2,32,4],[32,6,32,8],[32,10,32,12],[43,3,43,4],[43,7,43,8],[43,11,43,12],[32,14,32,16],[48,8,48,10],[49,8,49,10],[52,8,52,9],[41,1,44,1],[41,2,42,4],[41,5,44,5],[41,6,42,8],[41,9,44,9],[41,10,42,12],[51,3,53,4],[51,5,53,7],[46,6,46,8],[46,10,46,12],[34,17,37,17],[36,3,36,4],[36,7,36,8],[36,11,36,12],[36,15,36,16],[48,3,48,7],[48,11,50,15],[49,3,50,4],[49,5,50,7],[41,17,44,17],[34,13,37,13],[34,14,35,16],[39,2,39,4],[39,6,39,8],[39,10,39,12],[39,14,39,16],[34,10,35,12],[34,2,35,4],[34,5,37,5],[34,6,35,8],[34,9,37,9],[46,14,46,16],[43,15,43,16],[41,13,44,13]]}
[]
[]
[null,null,"Cálculo das horas das diligências\n(cfr. n.º 1 do artigo 5.º da Portaria 1386/2004, de 10 de novembro,\n com as alterações introduzidas pelo artigo 2.º da Portaria 26/2025/1, de 3 de fevereiro)"]
[null,null,{"$f":"IF(F5>0,\" \",\"Verifique Valor\")","v":" "},null,null,null,null,null,null,{"$f":"ISNUMBER(F5)","v":false}]
[null,null,"Nome do(a) Patrono(a):",null,null,"Dr(a) ",null,null,null,null,null,null,"Data da nomeação:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor da hora:",null,null,22]
[null,null,"1ª Sessão",null,null,null,"2ª Sessão",null,null,null,"3ª Sessão",null,null,null,"4ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D11-C11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H11-G11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L11-K11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P11-O11","v":"00:00:00"}]
[null,null,{"$f":"IF(D11<C11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H11<G11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L11<K11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P11<O11,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"5ª Sessão",null,null,null,"6ª Sessão",null,null,null,"7ªSessão",null,null,null,"8ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D18-C18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H18-G18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L18-K18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P18-O18","v":"00:00:00"}]
[null,null,{"$f":"IF(D18<C18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H18<G18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L18<K18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P18<O18,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"9ª Sessão",null,null,null,"10ª Sessão",null,null,null,"11ª Sessão",null,null,null,"12ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D25-C25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H25-G25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L25-K25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P25-O25","v":"00:00:00"}]
[null,null,{"$f":"IF(D25<C25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H25<G25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L25<K25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P25<O25,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"13ª Sessão",null,null,null,"14ª Sessão",null,null,null,"15ª Sessão",null,null,null,"16ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D32-C32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H32-G32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L32-K32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P32-O32","v":"00:00:00"}]
[null,null,{"$f":"IF(D32<C32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H32<G32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L32<K32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P32<O32,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"17ª Sessão",null,null,null,"18ª Sessão",null,null,null,"19ª Sessão",null,null,null,"20ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D39-C39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H39-G39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L39-K39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P39-O39","v":"00:00:00"}]
[null,null,{"$f":"IF(D39<C39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H39<G39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L39<K39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P39<O39,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"21ª Sessão",null,null,null,"22ª Sessão",null,null,null,"23ª Sessão",null,null,null,"24ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D46-C46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H46-G46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L46-K46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P46-O46","v":"00:00:00"}]
[null,null,{"$f":"IF(D46<C46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H46<G46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L46<K46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P46<O46,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,null,"Total de horas das Diligências",null,null,null,null,"Arredondamento das horas",null,null,"Montante total a liquidar "]
[null,null,null,"Soma das sessões em horas e minutos",null,"Com arredondamento em dias e horas",null,null,{"$f":"CEILING(D52, \"1:00\")","v":"00:00:00"}]
[]
[null,null,null,{"$f":"(E11+I11+M11+Q11+E18+I18+M18+Q18+E25+I25+M25+Q25+E32+I32+M32+Q32+E39+I39+M39+Q39+E46+I46+M46+Q46)","v":0},null,{"$f":"CONCATENATE(I54,\" Dia(s) e \",TEXT(K54,\"HH:MM\"),\" Horas\")","v":"0 Dia(s) e 00:00 Horas"},null,null,null,null,null,{"$f":"I50*24*$P$6","v":0}]
[null,null,null,null,null,null,null,null,"Dias Inteiros",null,"Horas"]
[null,null,null,null,null,null,null,null,{"$f":"INT(I50)","v":0},null,{"$f":"I50-I54","v":0},null,null,null,null,null,"v. 1.2026.05.22"]

{"sheet":"52 Diligências","index":3,"n_rows":103,"n_cols":17,"rows_kept":103,"cut":false,"hidden":false,"merged":[[2,2,2,16],[3,2,3,3],[3,4,3,5],[4,2,4,4],[4,5,4,6],[4,7,4,11],[4,12,4,14],[4,15,4,16],[5,2,5,3],[5,12,5,14],[5,15,5,16],[6,1,9,1],[6,2,7,4],[6,5,9,5],[6,6,7,8],[6,9,9,9],[6,10,7,12],[6,13,9,13],[13,1,16,1],[13,2,14,4],[13,5,16,5],[13,6,14,8],[13,9,16,9],[13,10,14,12],[6,14,7,16],[6,17,9,17],[8,3,8,4],[8,7,8,8],[8,11,8,12],[8,15,8,16],[13,13,16,13],[13,14,14,16],[13,17,16,17],[15,3,15,4],[15,7,15,8],[15,11,15,12],[15,15,15,16],[11,2,11,4],[11,6,11,8],[11,10,11,12],[11,14,11,16],[20,17,23,17],[22,3,22,4],[22,7,22,8],[22,11,22,12],[22,15,22,16],[18,2,18,4],[18,6,18,8],[18,10,18,12],[18,14,18,16],[19,2,19,3],[20,2,21,4],[20,5,23,5],[20,6,21,8],[20,9,23,9],[27,1,30,1],[27,2,28,4],[27,5,30,5],[27,6,28,8],[27,9,30,9],[27,10,28,12],[20,10,21,12],[20,13,23,13],[20,14,21,16],[20,1,23,1],[27,13,30,13],[27,14,28,16],[27,17,30,17],[29,3,29,4],[29,7,29,8],[29,11,29,12],[29,15,29,16],[25,2,25,4],[25,6,25,8],[25,10,25,12],[25,14,25,16],[32,2,32,4],[32,6,32,8],[32,10,32,12],[32,14,32,16],[34,1,37,1],[34,2,35,4],[34,5,37,5],[34,6,35,8],[34,9,37,9],[34,10,35,12],[41,1,44,1],[41,2,42,4],[41,5,44,5],[41,6,42,8],[41,9,44,9],[41,10,42,12],[34,13,37,13],[34,14,35,16],[34,17,37,17],[36,3,36,4],[36,7,36,8],[36,11,36,12],[36,15,36,16],[41,13,44,13],[41,14,42,16],[41,17,44,17],[43,3,43,4],[43,7,43,8],[43,11,43,12],[43,15,43,16],[39,2,39,4],[39,6,39,8],[39,10,39,12],[39,14,39,16],[74,2,74,4],[74,6,74,8],[74,10,74,12],[74,14,74,16],[46,2,46,4],[46,6,46,8],[46,10,46,12],[46,14,46,16],[97,3,97,7],[97,11,99,15],[98,3,99,4],[98,5,99,7],[48,14,49,16],[55,13,58,13],[76,13,79,13],[76,14,77,16],[88,2,88,4],[88,6,88,8],[88,10,88,12],[88,14,88,16],[95,14,95,16],[90,13,93,13],[90,14,91,16],[95,2,95,4],[48,1,51,1],[48,2,49,4],[48,5,51,5],[48,6,49,8],[48,9,51,9],[48,10,49,12],[48,13,51,13],[55,14,56,16],[69,1,72,1],[69,2,70,4],[69,5,72,5],[69,6,70,8],[69,9,72,9],[69,10,70,12],[62,1,65,1],[69,13,72,13],[69,14,70,16],[48,17,51,17],[50,3,50,4],[50,7,50,8],[50,11,50,12],[50,15,50,16],[53,2,53,4],[53,6,53,8],[53,10,53,12],[53,14,53,16],[55,17,58,17],[57,3,57,4],[57,7,57,8],[57,11,57,12],[57,15,57,16],[55,1,58,1],[55,2,56,4],[55,5,58,5],[55,6,56,8],[55,9,58,9],[55,10,56,12],[62,17,65,17],[64,3,64,4],[64,7,64,8],[64,11,64,12],[64,15,64,16],[60,2,60,4],[60,6,60,8],[60,10,60,12],[60,14,60,16],[61,2,61,3],[62,2,63,4],[62,5,65,5],[62,6,63,8],[62,9,65,9],[62,10,63,12],[62,13,65,13],[62,14,63,16],[69,17,72,17],[71,3,71,4],[71,7,71,8],[71,11,71,12],[71,15,71,16],[67,2,67,4],[67,6,67,8],[67,10,67,12],[67,14,67,16],[76,1,79,1],[76,2,77,4],[76,5,79,5],[76,6,77,8],[76,9,79,9],[76,10,77,12],[83,1,86,1],[83,2,84,4],[83,5,86,5],[83,6,84,8],[83,9,86,9],[83,10,84,12],[76,17,79,17],[78,3,78,4],[78,7,78,8],[78,11,78,12],[78,15,78,16],[83,13,86,13],[83,14,84,16],[83,17,86,17],[85,3,85,4],[85,7,85,8],[85,11,85,12],[85,15,85,16],[81,2,81,4],[81,6,81,8],[81,10,81,12],[81,14,81,16],[100,11,102,15],[90,17,93,17],[92,3,92,4],[92,7,92,8],[92,11,92,12],[92,15,92,16],[90,1,93,1],[90,2,91,4],[90,5,93,5],[90,6,91,8],[90,9,93,9],[90,10,91,12],[100,3,102,4],[100,5,102,7],[95,6,95,8],[95,10,95,12],[97,8,97,10],[98,8,98,10],[101,8,101,9]]}
[]
[]
[null,null,"Cálculo das horas das diligências\n(cfr. n.º 1 do artigo 5.º da Portaria 1386/2004, de 10 de novembro,\n com as alterações introduzidas pelo artigo 2.º da Portaria 26/2025/1, de 3 de fevereiro)"]
[null,null,{"$f":"IF(F5>0,\" \",\"Verifique Valor\")","v":" "},null,null,null,null,null,null,{"$f":"ISNUMBER(F5)","v":false}]
[null,null,"Nome do(a) Patrono(a):",null,null,"Dr(a) ",null,null,null,null,null,null,"Data da nomeação:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor da hora:",null,null,22]
[null,null,"1ª Sessão",null,null,null,"2ª Sessão",null,null,null,"3ª Sessão",null,null,null,"4ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D11-C11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H11-G11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L11-K11","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P11-O11","v":"00:00:00"}]
[null,null,{"$f":"IF(D11<C11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H11<G11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L11<K11,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P11<O11,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"5ª Sessão",null,null,null,"6ª Sessão",null,null,null,"7ªSessão",null,null,null,"8ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D18-C18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H18-G18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L18-K18","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P18-O18","v":"00:00:00"}]
[null,null,{"$f":"IF(D18<C18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H18<G18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L18<K18,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P18<O18,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"9ª Sessão",null,null,null,"10ª Sessão",null,null,null,"11ª Sessão",null,null,null,"12ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D25-C25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H25-G25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L25-K25","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P25-O25","v":"00:00:00"}]
[null,null,{"$f":"IF(D25<C25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H25<G25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L25<K25,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P25<O25,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"13ª Sessão",null,null,null,"14ª Sessão",null,null,null,"15ª Sessão",null,null,null,"16ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D32-C32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H32-G32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L32-K32","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P32-O32","v":"00:00:00"}]
[null,null,{"$f":"IF(D32<C32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H32<G32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L32<K32,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P32<O32,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"17ª Sessão",null,null,null,"18ª Sessão",null,null,null,"19ª Sessão",null,null,null,"20ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D39-C39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H39-G39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L39-K39","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P39-O39","v":"00:00:00"}]
[null,null,{"$f":"IF(D39<C39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H39<G39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L39<K39,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P39<O39,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"21ª Sessão",null,null,null,"22ª Sessão",null,null,null,"23ª Sessão",null,null,null,"24ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D46-C46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H46-G46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L46-K46","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P46-O46","v":"00:00:00"}]
[null,null,{"$f":"IF(D46<C46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H46<G46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L46<K46,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P46<O46,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"25ª Sessão",null,null,null,"26ª Sessão",null,null,null,"27ª Sessão",null,null,null,"28ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D53-C53","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H53-G53","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L53-K53","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P53-O53","v":"00:00:00"}]
[null,null,{"$f":"IF(D53<C53,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H53<G53,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L53<K53,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P53<O53,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"29ª Sessão",null,null,null,"30ª Sessão",null,null,null,"31ªSessão",null,null,null,"32ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D60-C60","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H60-G60","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L60-K60","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P60-O60","v":"00:00:00"}]
[null,null,{"$f":"IF(D60<C60,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H60<G60,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L60<K60,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P60<O60,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"33ª Sessão",null,null,null,"34ª Sessão",null,null,null,"35ª Sessão",null,null,null,"36ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D67-C67","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H67-G67","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L67-K67","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P67-O67","v":"00:00:00"}]
[null,null,{"$f":"IF(D67<C67,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H67<G67,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L67<K67,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P67<O67,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"37ª Sessão",null,null,null,"38ª Sessão",null,null,null,"39ª Sessão",null,null,null,"40ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D74-C74","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H74-G74","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L74-K74","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P74-O74","v":"00:00:00"}]
[null,null,{"$f":"IF(D74<C74,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H74<G74,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L74<K74,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P74<O74,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"41ª Sessão",null,null,null,"42ª Sessão",null,null,null,"43ª Sessão",null,null,null,"44ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D81-C81","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H81-G81","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L81-K81","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P81-O81","v":"00:00:00"}]
[null,null,{"$f":"IF(D81<C81,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H81<G81,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L81<K81,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P81<O81,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"45ª Sessão",null,null,null,"46ª Sessão",null,null,null,"47ª Sessão",null,null,null,"48ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D88-C88","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H88-G88","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L88-K88","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P88-O88","v":"00:00:00"}]
[null,null,{"$f":"IF(D88<C88,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H88<G88,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L88<K88,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P88<O88,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,"49ª Sessão",null,null,null,"50ª Sessão",null,null,null,"51ª Sessão",null,null,null,"52ª Sessão"]
[]
[null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:",null,null,null,"Data:"]
[null,null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total ",null,"Hora de início","Hora de fim","Total "]
[null,null,"00:00:00","00:00:00",{"$f":"D95-C95","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"H95-G95","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"L95-K95","v":"00:00:00"},null,"00:00:00","00:00:00",{"$f":"P95-O95","v":"00:00:00"}]
[null,null,{"$f":"IF(D95<C95,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(H95<G95,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(L95<K95,\"Verifique as horas!!\",\" \")","v":" "},null,null,null,{"$f":"IF(P95<O95,\"Verifique as horas!!\",\" \")","v":" "}]
[]
[null,null,null,"Total de horas das Diligências",null,null,null,null,"Arredondamento das horas",null,null,"Montante total a liquidar "]
[null,null,null,"Soma das sessões em horas e minutos",null,"Com arredondamento em dias e horas",null,null,{"$f":"CEILING(D101, \"1:00\")","v":"00:00:00"}]
[]
[null,null,null,{"$f":"(E11+I11+M11+Q11+E18+I18+M18+Q18+E25+I25+M25+Q25+E32+I32+M32+Q32+E39+I39+M39+Q39+E46+I46+M46+Q46+E53+I53+M53+Q53+E60+I60+M60+Q60+E67+I67+M67+Q67+E74+I74+M74+Q74+E81+I81+M81+Q81+E88+I88+M88+Q88+E95+I95+M95+Q95)","v":0},null,{"$f":"CONCATENATE(I103,\" Dia(s) e \",TEXT(K103,\"HH:MM\"),\" Horas\")","v":"0 Dia(s) e 00:00 Horas"},null,null,null,null,null,{"$f":"I99*24*$P$6","v":0}]
[null,null,null,null,null,null,null,null,"Dias Inteiros",null,"Horas"]
[null,null,null,null,null,null,null,null,{"$f":"INT(I99)","v":0},null,{"$f":"I99-I103","v":0},null,null,null,null,null,"v. 1.2026.05.22"]