{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1","Wasilic","Wasilic   дополненый","Alex_ST","ВОПРОС"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"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":"1","index":0,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,11,3,11],[0,1,0,2],[1,0,1,3],[1,4,1,7],[1,8,3,8],[1,9,1,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,9,3,9],[2,10,3,10]]}
["с","2014-03-01",null,"по","2014-03-31"]
[{"$f":"TODAY()","v":"2014-03-18"},null,null,null,{"$f":"NOW()-TODAY()","v":"19:24:47.430"},null,null,null,null,null,null,null,null,"Два макроса из поста № 1 объединенных  GoTo "]
["№ п /п","служ-бове поле","ДАТА","№  ","ФИО ",null,null,null,null,"ПОЧА-ТОК РОБОТИ","ЗАКІН-ЧЕННЯ РОБОТИ","ЧАС РОБОТИ",null,"Для проверки работы нужно ввети любые данные в столбец Е или F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Также макрос срабатывает при двойном щелчке на данных ячейках,"]
[{"$f":"IF(C5>0,1, 0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J5>0,K5=0),$E$2-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"00:00:00"},null,"что не смертельно, но не совсем правильно"]
[{"$f":"IF(AND(A5=1, C6>0), SUM(A5+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[{"$f":"IF(AND(A6-A5=1, C7>0), SUM(A6+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]

{"sheet":"Wasilic","index":1,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,11,3,11],[0,1,0,2],[1,0,1,3],[1,4,1,7],[1,8,3,8],[1,9,1,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,9,3,9],[2,10,3,10]]}
["с","2014-03-01",null,"по","2014-03-31"]
[{"$f":"TODAY()","v":"2014-03-18"},null,null,null,{"$f":"NOW()-TODAY()","v":"19:24:47.430"},null,null,null,null,null,null,null,null,"Макрос Wasilic, СПАСИБО,"]
["№ п /п","служ-бове поле","ДАТА","№  ","ФИО ",null,null,null,null,"ПОЧА-ТОК РОБОТИ","ЗАКІН-ЧЕННЯ РОБОТИ","ЧАС РОБОТИ",null,"Для проверки работы нужно ввети любые данные в столбец Е или F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Также макрос срабатывает при двойном щелчке на данных ячейках,"]
[{"$f":"IF(C5>0,1, 0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J5>0,K5=0),$E$2-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"00:00:00"},null,"что не смертельно, но не совсем правильно"]
[{"$f":"IF(AND(A5=1, C6>0), SUM(A5+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[{"$f":"IF(AND(A6-A5=1, C7>0), SUM(A6+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]

{"sheet":"Wasilic   дополненый","index":2,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,11,3,11],[1,0,1,3],[1,4,1,7],[1,8,3,8],[1,9,1,11],[2,10,3,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,9,3,9]]}
["с","2014-03-01",null,"по","2014-03-31"]
[{"$f":"TODAY()","v":"2014-03-18"},null,null,null,{"$f":"NOW()-TODAY()","v":"19:24:47.430"},null,null,null,null,null,null,null,null,"Макрос Wasilic,чуть поправлен  по пинку , контролирует что ячейка не нулевая СПАСИБО,"]
["№ п /п","служ-бове поле","ДАТА","№  ","ФИО ",null,null,null,null,"ПОЧА-ТОК РОБОТИ","ЗАКІН-ЧЕННЯ РОБОТИ","ЧАС РОБОТИ",null,"Для проверки работы нужно ввети любое число в столбец Е или F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Также макрос срабатывает при двойном щелчке на данных ячейках,"]
[{"$f":"IF(C5>0,1, 0)","v":0},null,null,null,null,2,null,null,null,"11:02:49",null,{"$f":"IF(AND(J5>0,K5=0),$E$2-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"08:21:58.430"},null,"что не смертельно, но не совсем правильно"]
[{"$f":"IF(AND(A5=1, C6>0), SUM(A5+1), 0)","v":0},null,null,null,null,2,null,null,null,"11:02:49",null,"08:21:58.430",null,"УЖЕ НЕ СРАБАТЫВАЕТ, ПОСЛЕ ПОДСКАЗКИ   Wasilic"]
[{"$f":"IF(AND(A6-A5=1, C7>0), SUM(A6+1), 0)","v":0},null,null,null,null,2,null,null,null,"11:02:50",null,"08:21:57.430",null,"как проверить в рабочем диапазоне, что введено число, а не просто дважды топнули мышкой"]
[0,null,null,null,null,2,null,null,null,"11:02:51",null,"08:21:56.430",null,"Так наверное:   If Val(Target)>0 then"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]

{"sheet":"Alex_ST","index":3,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,11,3,11],[0,1,0,2],[1,0,1,3],[1,4,1,7],[1,8,3,8],[1,9,1,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,9,3,9],[2,10,3,10]]}
["с","2014-03-01",null,"по","2014-03-31"]
[{"$f":"TODAY()","v":"2014-03-18"},null,null,null,{"$f":"NOW()-TODAY()","v":"19:24:47.430"},null,null,null,null,null,null,null,null,"Макрос  Alex_ST",null,null,", упорно НЕ работает"]
["№ п /п","служ-бове поле","ДАТА","№  ","ФИО ",null,null,null,null,"ПОЧА-ТОК РОБОТИ","ЗАКІН-ЧЕННЯ РОБОТИ","ЧАС РОБОТИ"]
[]
[{"$f":"IF(C5>0,1, 0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J5>0,K5=0),$E$2-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"00:00:00"}]
[{"$f":"IF(AND(A5=1, C6>0), SUM(A5+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[{"$f":"IF(AND(A6-A5=1, C7>0), SUM(A6+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]

{"sheet":"ВОПРОС","index":4,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,11,3,11],[0,1,0,2],[1,0,1,3],[1,4,1,7],[1,8,3,8],[1,9,1,11],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,9,3,9],[2,10,3,10]]}
["с","2014-03-01",null,"по","2014-03-31"]
[{"$f":"TODAY()","v":"2014-03-18"},null,null,null,{"$f":"NOW()-TODAY()","v":"19:24:47.430"},null,null,null,null,null,null,null,null,"Макрос Wasilic,чуть поправлен  по пинку , контролирует что ячейка не нулевая СПАСИБО,"]
["№ п /п","СЛУЖЕБНОЕ поле","ДАТА","№   ТАБЕЛЯ","ФИО ","СМЕНА",null,null,null,"начало РАБОТИ","ОКОНЧАНИЕ РАБОТИ","ВРЕМЯ РАБОТИ",null,"Для проверки работы нужно ввети любое число в столбец Е или F"]
[]
[{"$f":"IF(C5>0,1, 0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J5>0,K5=0),$E$2-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"00:00:00"}]
[{"$f":"IF(AND(A5=1, C6>0), SUM(A5+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[{"$f":"IF(AND(A6-A5=1, C7>0), SUM(A6+1), 0)","v":0},null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00",null,"ВОПРОС:  ","При вставке времени макросом вставляются также секунды,"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00",null,null,"как поправить чтобы вставлялись только часы и минуты, "]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00",null,null,"как при вставке   с помощью комбинации клавиш Ctrl+Shift+:"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]
[0,null,null,null,null,null,null,null,null,null,null,"00:00:00"]