{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Formula","Dataset","IF","MIN","MIN,IF,SUM","40hrs","VBA","Payment"],"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":"Formula","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,5],[9,2,9,3],[8,2,8,3],[7,2,7,3],[6,2,6,3],[5,2,5,3],[4,2,4,3]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday",null,"Entry","Exit"]
[null,"2023-01-02","Monday",null,"08:00:00","17:00:00"]
[null,"2023-01-03","Tuesday",null,"08:40:00","20:30:00"]
[null,"2023-01-04","Wednesday",null,"07:30:00","21:20:00"]
[null,"2023-01-05","Thursday",null,"09:00:00","17:20:00"]
[null,"2023-01-06","Friday",null,"08:10:00","18:50:00"]
[]
[]
[null,"Method","Overtime","Overtime Formula","Double Time","Double Time Formula"]
[null,"IF function",{"$f":"IF!H8","v":4},{"$f":"_xlfn.FORMULATEXT(IF!H8)","v":"=IF(F8-G8<4, F8-G8,4)"},{"$f":"IF!I8","v":1.8333333333333321},{"$f":"_xlfn.FORMULATEXT(IF!I8)","v":"=IF(F8-12>0,F8-12,0)"}]
[null,"MIN function",{"$f":"MIN!H8","v":4},{"$f":"_xlfn.FORMULATEXT(MIN!H8)","v":"=MIN(F8-G8,4)"},{"$f":"MIN!I8","v":1.8333333333333321},{"$f":"_xlfn.FORMULATEXT(MIN!I8)","v":"=F8-(G8+H8)"}]
[null,"MIN, IF, SUM function",{"$f":"'MIN,IF,SUM'!H8","v":4},{"$f":"_xlfn.FORMULATEXT('MIN,IF,SUM'!H8)","v":"=IF(F8-G8<4, F8-G8,4)"},{"$f":"'MIN,IF,SUM'!I8","v":1.8333333333333321},{"$f":"_xlfn.FORMULATEXT('MIN,IF,SUM'!I8)","v":"=F8-(SUM(G8:H8))"}]
[null,"VBA Macro",4,null,2]
[null,"Weekly",10,{"$f":"_xlfn.FORMULATEXT('40hrs'!H11)","v":"=MIN(F11-G11,10)"},4,{"$f":"_xlfn.FORMULATEXT('40hrs'!I11)","v":"=F11-SUM(G11:H11)"}]

{"sheet":"Dataset","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit"]
[null,"2023-01-02","Monday","08:00:00","17:00:00"]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00"]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00"]
[null,"2023-01-05","Thursday","09:00:00","17:20:00"]
[null,"2023-01-06","Friday","08:10:00","18:50:00"]

{"sheet":"IF","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit","Duty Hour","General Duty","Overtime","Double Time"]
[null,"2023-01-02","Monday","08:00:00","17:00:00",{"$f":"(E6-D6)*24","v":9.0000000000000018},8,{"$f":"IF(F6-G6<4, F6-G6,4)","v":1.0000000000000018},{"$f":"IF(F6-12>0,F6-12,0)","v":0}]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00",{"$f":"(E7-D7)*24","v":11.833333333333332},8,{"$f":"IF(F7-G7<4, F7-G7,4)","v":3.8333333333333321},{"$f":"IF(F7-12>0,F7-12,0)","v":0}]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00",13.833333333333332,8,4,{"$f":"IF(F8-12>0,F8-12,0)","v":1.8333333333333321}]
[null,"2023-01-05","Thursday","09:00:00","17:20:00",8.3333333333333321,8,0.33333333333333215,{"$f":"IF(F9-12>0,F9-12,0)","v":0}]
[null,"2023-01-06","Friday","08:10:00","18:50:00",10.666666666666668,8,2.6666666666666679,0]

{"sheet":"MIN","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit","Duty Hour","General Duty","Overtime","Double Time"]
[null,"2023-01-02","Monday","08:00:00","17:00:00",{"$f":"(E6-D6)*24","v":9.0000000000000018},{"$f":"MIN(F6,8)","v":8},{"$f":"MIN(F6-G6,4)","v":1.0000000000000018},{"$f":"F6-(G6+H6)","v":0}]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00",{"$f":"(E7-D7)*24","v":11.833333333333332},{"$f":"MIN(F7,8)","v":8},{"$f":"MIN(F7-G7,4)","v":3.8333333333333321},{"$f":"F7-(G7+H7)","v":0}]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00",13.833333333333332,8,4,1.8333333333333321]
[null,"2023-01-05","Thursday","09:00:00","17:20:00",8.3333333333333321,8,0.33333333333333215,0]
[null,"2023-01-06","Friday","08:10:00","18:50:00",10.666666666666668,8,2.6666666666666679,0]

{"sheet":"MIN,IF,SUM","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit","Duty Hour","General Duty","Overtime","Double Time"]
[null,"2023-01-02","Monday","08:00:00","17:00:00",{"$f":"(E6-D6)*24","v":9.0000000000000018},{"$f":"MIN(F6,8)","v":8},{"$f":"IF(F6-G6<4, F6-G6,4)","v":1.0000000000000018},{"$f":"F6-(SUM(G6:H6))","v":0}]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00",{"$f":"(E7-D7)*24","v":11.833333333333332},{"$f":"MIN(F7,8)","v":8},{"$f":"IF(F7-G7<4, F7-G7,4)","v":3.8333333333333321},{"$f":"F7-(SUM(G7:H7))","v":0}]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00",13.833333333333332,8,4,1.8333333333333321]
[null,"2023-01-05","Thursday","09:00:00","17:20:00",8.3333333333333321,8,0.33333333333333215,0]
[null,"2023-01-06","Friday","08:10:00","18:50:00",10.666666666666668,8,2.6666666666666679,0]

{"sheet":"40hrs","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,8],[10,3,10,4]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit","Duty Hour","General Duty","Overtime","Double Time"]
[null,"2023-01-02","Monday","08:00:00","17:00:00",{"$f":"(E6-D6)*24","v":9.0000000000000018},8,{"$f":"IF(F6-G6<4, F6-G6,4)","v":1.0000000000000018},{"$f":"IF(F6-12>0,F6-12,0)","v":0}]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00",{"$f":"(E7-D7)*24","v":11.833333333333332},8,{"$f":"IF(F7-G7<4, F7-G7,4)","v":3.8333333333333321},0]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00",13.833333333333332,8,4,{"$f":"IF(F8-12>0,F8-12,0)","v":1.8333333333333321}]
[null,"2023-01-05","Thursday","09:00:00","17:20:00",8.3333333333333321,8,0.33333333333333215,{"$f":"IF(F9-12>0,F9-12,0)","v":0}]
[null,"2023-01-06","Friday","08:10:00","18:50:00",10.666666666666668,8,2.6666666666666679,0]
[null,null,null,"Total",null,{"$f":"SUM(F6:F10)","v":53.666666666666671},40,{"$f":"MIN(F11-G11,10)","v":10},{"$f":"F11-SUM(G11:H11)","v":3.6666666666666714}]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,8]]}
[]
[]
[null,"Weekly Timesheet of Mr. Liam Oliver"]
[]
[null,"Date","Weekday","Entry","Exit","Duty Hour","General Duty","Overtime","Double Time"]
[null,"2023-01-02","Monday","08:00:00","17:00:00"]
[null,"2023-01-03","Tuesday","08:40:00","20:30:00"]
[null,"2023-01-04","Wednesday","07:30:00","21:20:00"]
[null,"2023-01-05","Thursday","09:00:00","17:20:00"]
[null,"2023-01-06","Friday","08:10:00","18:50:00"]

{"sheet":"Payment","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,2,6,8]]}
[]
[]
[]
[]
[null,null,"To Use as Calculator Please Right-Click on \"Payment\" Worksheet"]