{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Introduction","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Calculate Working \nHours during \nthe shift time"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Sheet2","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Calculate - Working Hours between - 10 Pm to 6 Am"]
["Time Status","In Time","Out time","Difference","Formula"]
["Correct In - Early Out","22:00:00","03:00:00",{"$f":"IF(AND(HOUR(B3)=22, HOUR(C3)= 6), 8, IF(AND( HOUR(B3)>=22, HOUR(C3)<=6), 24 - (HOUR(B3) - HOUR(C3)),IF(AND(HOUR(B3)>22,HOUR(C3)> 6), 24 - HOUR(B3)+  6,IF(AND(HOUR(B3)<22,HOUR(C3)< 6,HOUR(B3)>6), 2 + HOUR(C3),IF(AND(HOUR(B3)>=1,HOUR(C3)< 6), HOUR(C3)-HOUR(B3))))))","v":5}," IF(AND( HOUR(B3)>=22, HOUR(C3)<=6), 24 - (HOUR(B3) - HOUR(C3))"]
["Late In - Late Out","23:00:00","10:00:00",{"$f":"IF(AND(HOUR(B4)=22, HOUR(C4)= 6), 8, IF(AND( HOUR(B4)>=22, HOUR(C4)<=6), 24 - (HOUR(B4) - HOUR(C4)),IF(AND(HOUR(B4)>22,HOUR(C4)> 6), 24 - HOUR(B4)+  6,IF(AND(HOUR(B4)<22,HOUR(C4)< 6,HOUR(B4)>6), 2 + HOUR(C4),IF(AND(HOUR(B4)>=1,HOUR(C4)< 6), HOUR(C4)-HOUR(B4))))))","v":7},"IF(AND(HOUR(B3)>22,HOUR(C3)> 6), 24 - HOUR(B3)+  6"]
["No Working Hours","18:00:00","08:00:00",false,"Doesn't fall under this criteria"]
["Early In - Early Out","21:00:00","02:00:00",4,"IF(AND(HOUR(B6)<22,HOUR(C6)< 6,HOUR(B6)>6), 2 + HOUR(C6)"]
["No Working Hours","08:00:00","12:00:00",false,"Doesn't fall under this criteria"]
["Corrent in - Correct Out","22:00:00","06:00:00",8,"IF(AND(HOUR(B8)=22, HOUR(C8)= 6), 8"]
["Late in - Early out","23:00:00","04:00:00",5," IF(AND( HOUR(B9)>=22, HOUR(C9)<=6), 24 - (HOUR(B9) - HOUR(C9))"]
["Late In - Late Out","23:00:00","08:00:00",7,"IF(AND(HOUR(B10)>22,HOUR(C10)> 6), 24 - HOUR(B10)+  6"]
["In After 12 Am","02:00:00","04:00:00",2,"IF(AND(HOUR(B11)>=1,HOUR(C11)< 6), HOUR(C11)-HOUR(B11)"]