{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"data","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,7,3,8],[0,1,1,11],[2,2,3,5]]}
[null,"درج ساعت سیستم"]
[]
[null,null,"برای جلوگیری از خطا در قسمت \"ساعت ورود\" ساعت را به این شکل 7:00 و در قسمت ساعت خروج ساعت را به این شکل 16:00 وارد کنید."]
[null,null,null,null,null,null,null,"محاسبه ساعت کاری "]
[null,null,"روز","ساعت ورود","مرخصي ساعتي","ساعت خروج",null,"با استفاده از IF","با استفاده از \" >\"",null,"ساعت کارکرد استاندارد","کسری","اضافه کار"]
[null,null,13940101,"16:43:36",null,"17:50:00",null,{"$f":"IF(F6>D6,F6-D6,1-D6+F6)","v":4.6111111111110992E-2},{"$f":"F6-D6+(F6<=D6)","v":4.6111111111110992E-2},null,0.375,{"$f":"IF(K6-H6>0,K6-H6,\"\")","v":0.32888888888888901},{"$f":"IF(H6-K6>0,H6-K6,\"\")","v":""}]
[null,null,13940101,"07:00:00",null,"16:00:00",null,{"$f":"IF(F7>D7,F7-D7,1-D7+F7)","v":0.37499999999999994},{"$f":"F7-D7+(F7<=D7)","v":0.37499999999999994},null,0.375,{"$f":"IF(K7-H7>0,K7-H7,\"\")","v":5.5511151231257827E-17},{"$f":"IF(H7-K7>0,H7-K7,\"\")","v":""}]
[null,null,13940101,"08:00:00",8.3333333333333329E-2,"15:00:00",null,0.29166666666666669,0.29166666666666669,null,0.375,8.3333333333333315E-2,""]
[null,null,"1394/01/01","22:00:00",null,"07:00:00",null,0.37500000000000006,0.375,null,0.375,"",5.5511151231257827E-17]
[null,null,"1394/01/02","07:00:00",4.1666666666666664E-2,"15:00:00",null,0.33333333333333331,0.33333333333333331,null,0.375,4.1666666666666685E-2,""]
[null,null,"1394/01/02","08:00:00",null,"18:00:00",null,0.41666666666666669,0.41666666666666669,null,0.375,"",4.1666666666666685E-2]
[null,null,"1394/01/02","07:00:00",null,"19:00:00",null,0.49999999999999994,0.49999999999999994,null,0.375,"",0.12499999999999994]
[null,null,"1394/01/02","22:10:00",null,"07:30:00",null,0.38888888888888884,0.38888888888888884,null,0.375,"",1.388888888888884E-2]
[]
[null,null,null,null,{"$f":"SUM(E6:E13)","v":0.125},null,null,{"$f":"SUM(H6:H13)","v":2.7266666666666666},{"$f":"SUM(I6:I13)","v":2.7266666666666666},null,{"$f":"SUM(K6:K13)","v":3},{"$f":"SUM(L6:L13)","v":0.45388888888888906},{"$f":"SUM(M6:M13)","v":0.18055555555555552}]