{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Setup Here","Semi-Monthly Timesheets","Summary Timesheet"],"not_rendered":{"charts":0,"images":4,"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":"Setup Here","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Semimonthly Timesheets"]
["Please list the date you want the pay sheet to start. Usually starts on a Sunday"]
["Pay Period Start Date","2022-06-01"]
["Overtime starts after: ",40,"hours"]
[]
[]
[]
["Please edit this list to show the employees you want to track time for"]
[null,"First Name","Last Name","Emp #"]
["Employee","John","Doe",100]

{"sheet":"Semi-Monthly Timesheets","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,9,12,9],[3,0,3,7],[23,0,23,7]]}
[]
[]
[{"$f":"_xlfn.CONCAT('Setup Here'!$C$11,\", \", 'Setup Here'!$B$11,\" #\",'Setup Here'!$D$11)","v":"Doe, John #100"},"Time In","Break In","Break Out","Time Out","Regular Hours","OverTime","Total"]
["1st Half of the Month"]
[{"$f":"'Setup Here'!$B$4","v":"2022-06-01"},43641.380972222221,43641.533009259256,43641.557395833333,43641.760625000003,{"$f":"IF((((C5-B5)+(E5-D5))*24)>8,8,((C5-B5)+(E5-D5))*24)","v":8},{"$f":"IF(H5>8,H5-8,0)","v":0.52638888888759539},{"$f":"(((IF($E5<$B5,$E5+1,$E5)-$B5)-(IF($D5<$C5,$D5+1,$D5)-$C5))-(INT((IF($E5<$B5,$E5+1,$E5)-$B5)-(IF($D5<$C5,$D5+1,$D5)-$C5))))*24","v":8.5263888888875954}]
[{"$f":"'Setup Here'!$B$4+1","v":"2022-06-02"},null,null,null,null,{"$f":"IF((((C6-B6)+(E6-D6))*24)>8,8,((C6-B6)+(E6-D6))*24)","v":0},0,{"$f":"(((IF($E6<$B6,$E6+1,$E6)-$B6)-(IF($D6<$C6,$D6+1,$D6)-$C6))-(INT((IF($E6<$B6,$E6+1,$E6)-$B6)-(IF($D6<$C6,$D6+1,$D6)-$C6))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+2","v":"2022-06-03"},null,null,null,null,{"$f":"IF((((C7-B7)+(E7-D7))*24)>8,8,((C7-B7)+(E7-D7))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+3","v":"2022-06-04"},null,null,null,null,{"$f":"IF((((C8-B8)+(E8-D8))*24)>8,8,((C8-B8)+(E8-D8))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+4","v":"2022-06-05"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+5","v":"2022-06-06"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+6","v":"2022-06-07"},null,null,null,null,0,{"$f":"IF(H11>8,H11-8,0)","v":0},{"$f":"(((IF($E11<$B11,$E11+1,$E11)-$B11)-(IF($D11<$C11,$D11+1,$D11)-$C11))-(INT((IF($E11<$B11,$E11+1,$E11)-$B11)-(IF($D11<$C11,$D11+1,$D11)-$C11))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+7","v":"2022-06-08"},null,null,null,null,0,{"$f":"IF(H12>8,H12-8,0)","v":0},{"$f":"(((IF($E12<$B12,$E12+1,$E12)-$B12)-(IF($D12<$C12,$D12+1,$D12)-$C12))-(INT((IF($E12<$B12,$E12+1,$E12)-$B12)-(IF($D12<$C12,$D12+1,$D12)-$C12))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+8","v":"2022-06-09"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+9","v":"2022-06-10"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+10","v":"2022-06-11"},null,null,null,null,0,{"$f":"IF(H15>8,H15-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+11","v":"2022-06-12"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+12","v":"2022-06-13"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+13","v":"2022-06-14"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+14","v":"2022-06-15"},null,null,null,null,0,{"$f":"IF(H19>8,H19-8,0)","v":0},0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F5:F19)","v":8}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G5:G19))","v":0.52638888888759539}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H5:H19)","v":8.5263888888875954}]
[]
["2nd Half of the Month"]
[{"$f":"'Setup Here'!$B$4+15","v":"2022-06-16"},null,null,null,null,{"$f":"IF((((C25-B25)+(E25-D25))*24)>8,8,((C25-B25)+(E25-D25))*24)","v":0},{"$f":"IF(H25>8,H25-8,0)","v":0},{"$f":"(((IF($E25<$B25,$E25+1,$E25)-$B25)-(IF($D25<$C25,$D25+1,$D25)-$C25))-(INT((IF($E25<$B25,$E25+1,$E25)-$B25)-(IF($D25<$C25,$D25+1,$D25)-$C25))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+16","v":"2022-06-17"},null,null,null,null,{"$f":"IF((((C26-B26)+(E26-D26))*24)>8,8,((C26-B26)+(E26-D26))*24)","v":0},0,{"$f":"(((IF($E26<$B26,$E26+1,$E26)-$B26)-(IF($D26<$C26,$D26+1,$D26)-$C26))-(INT((IF($E26<$B26,$E26+1,$E26)-$B26)-(IF($D26<$C26,$D26+1,$D26)-$C26))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+17","v":"2022-06-18"},null,null,null,null,{"$f":"IF((((C27-B27)+(E27-D27))*24)>8,8,((C27-B27)+(E27-D27))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+18","v":"2022-06-19"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+19","v":"2022-06-20"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+20","v":"2022-06-21"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+21","v":"2022-06-22"},null,null,null,null,0,{"$f":"IF(H31>8,H31-8,0)","v":0},{"$f":"(((IF($E31<$B31,$E31+1,$E31)-$B31)-(IF($D31<$C31,$D31+1,$D31)-$C31))-(INT((IF($E31<$B31,$E31+1,$E31)-$B31)-(IF($D31<$C31,$D31+1,$D31)-$C31))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+22","v":"2022-06-23"},null,null,null,null,{"$f":"IF((((C32-B32)+(E32-D32))*24)>8,8,((C32-B32)+(E32-D32))*24)","v":0},{"$f":"IF(H32>8,H32-8,0)","v":0},{"$f":"(((IF($E32<$B32,$E32+1,$E32)-$B32)-(IF($D32<$C32,$D32+1,$D32)-$C32))-(INT((IF($E32<$B32,$E32+1,$E32)-$B32)-(IF($D32<$C32,$D32+1,$D32)-$C32))))*24","v":0}]
[{"$f":"'Setup Here'!$B$4+23","v":"2022-06-24"},null,null,null,null,{"$f":"IF((((C33-B33)+(E33-D33))*24)>8,8,((C33-B33)+(E33-D33))*24)","v":0},0,0]
[{"$f":"'Setup Here'!$B$4+24","v":"2022-06-25"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+25","v":"2022-06-26"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+26","v":"2022-06-27"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+27","v":"2022-06-28"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+28","v":"2022-06-29"},null,null,null,null,0,0,0]
[{"$f":"'Setup Here'!$B$4+29","v":"2022-06-30"},null,null,null,null,{"$f":"IF((((C39-B39)+(E39-D39))*24)>8,8,((C39-B39)+(E39-D39))*24)","v":0},{"$f":"IF(H39>8,H39-8,0)","v":0},0]
[{"$f":"'Setup Here'!$B$4+30","v":"2022-07-01"},null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Regular Hours",{"$f":"SUM(F25:F40)","v":0}]
[null,null,null,null,null,null,"Overtime Hours",{"$f":"(SUM(G25:G40))","v":0}]
[null,null,null,null,null,null,"Total hours",{"$f":"SUM(H25:H40)","v":0}]

{"sheet":"Summary Timesheet","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["SUMMARY OF SEMIMONTHLY TIMESHEET DATA"]
[]
["EMPLOYEE","Total Regular hours","Total Overtime Hours ","Total Hours"]
["1st Half of the Month",{"$f":"'Semi-Monthly Timesheets'!H20","v":8},{"$f":"'Semi-Monthly Timesheets'!H21","v":0.52638888888759539},{"$f":"SUM(B5+C5)","v":8.5263888888875954}]
["2nd Half of the Month",{"$f":"'Semi-Monthly Timesheets'!H41","v":0},{"$f":"'Semi-Monthly Timesheets'!H42","v":0},{"$f":"SUM(B6+C6)","v":0}]
[]
[null,null,"REGULAR HOURS",{"$f":"SUM(B5:B6)","v":8}]
[null,null,"OVERTIME HOURS",{"$f":"SUM(C5:C6)","v":0.52638888888759539}]
[null,null,"TOTAL",{"$f":"SUM(D5:D6)","v":8.5263888888875954}]