{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BiWeekly","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"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":"BiWeekly","index":0,"n_rows":60,"n_cols":21,"rows_kept":60,"cut":false,"hidden":false,"merged":[[15,13,16,13],[13,11,14,11],[3,12,3,20],[9,10,9,15],[9,3,9,8],[19,17,20,17],[13,13,14,13],[17,13,18,13],[17,15,18,15],[19,8,20,8],[15,16,16,16],[13,16,14,16],[15,17,16,17],[15,15,16,15],[13,18,14,18],[15,18,16,18],[13,17,14,17],[12,0,12,13],[15,6,16,6],[17,6,18,6],[6,0,6,10],[13,19,13,20],[13,15,14,15],[11,12,11,13],[2,0,2,10],[3,0,3,10],[1,0,1,20],[4,12,4,20],[5,12,5,20],[2,12,2,20],[4,0,4,10],[11,0,11,1],[11,2,11,4],[5,0,5,10],[11,18,11,19],[13,12,14,12],[13,14,14,14],[15,3,16,3],[15,4,16,4],[15,2,16,2],[12,14,12,17],[15,14,16,14],[19,12,20,12],[19,14,20,14],[19,13,20,13],[19,7,20,7],[19,11,20,11],[19,10,20,10],[19,15,20,15],[13,0,13,8],[13,9,14,9],[15,1,16,1],[19,16,20,16],[17,11,18,11],[15,11,16,11],[13,10,14,10],[17,1,18,1],[17,7,18,7],[17,12,18,12],[15,12,16,12],[17,14,18,14],[23,8,24,8],[25,11,26,11],[25,8,26,8],[25,13,26,13],[25,7,26,7],[25,9,26,9],[0,0,0,20],[21,16,22,16],[17,16,18,16],[17,17,18,17],[19,18,20,18],[17,18,18,18],[11,5,11,6],[11,7,11,9],[17,10,18,10],[15,9,16,9],[19,9,20,9],[15,10,16,10],[19,6,20,6],[17,8,18,8],[17,9,18,9],[15,7,16,7],[15,8,16,8],[21,6,22,6],[21,8,22,8],[21,7,22,7],[15,0,16,0],[17,0,18,0],[27,3,28,3],[27,5,28,5],[19,5,20,5],[27,2,28,2],[21,0,22,0],[23,0,24,0],[25,3,26,3],[21,1,22,1],[21,5,22,5],[25,5,26,5],[19,0,20,0],[17,4,18,4],[15,5,16,5],[25,4,26,4],[23,1,24,1],[19,1,20,1],[17,5,18,5],[17,2,18,2],[25,1,26,1],[27,0,28,0],[27,14,28,14],[21,15,22,15],[23,18,24,18],[27,18,28,18],[25,16,26,16],[25,15,26,15],[27,15,28,15],[27,17,28,17],[25,0,26,0],[27,6,28,6],[27,11,28,11],[25,14,26,14],[23,11,24,11],[21,14,22,14],[23,9,24,9],[21,9,22,9],[27,10,28,10],[27,9,28,9],[21,11,22,11],[27,7,28,7],[23,6,24,6],[23,15,24,15],[31,0,31,8],[31,9,32,9],[25,2,26,2],[23,5,24,5],[31,11,32,11],[27,4,28,4],[27,1,28,1],[30,0,30,20],[29,0,29,8],[31,19,31,20],[23,7,24,7],[25,6,26,6],[23,14,24,14],[25,17,26,17],[23,17,24,17],[23,13,24,13],[25,12,26,12],[23,10,24,10],[31,10,32,10],[31,12,32,12],[31,17,32,17],[31,15,32,15],[27,8,28,8],[23,16,24,16],[25,10,26,10],[21,10,22,10],[33,18,34,18],[33,12,34,12],[33,13,34,13],[31,18,32,18],[31,13,32,13],[27,13,28,13],[27,12,28,12],[27,16,28,16],[25,18,26,18],[23,12,24,12],[21,12,22,12],[21,18,22,18],[21,13,22,13],[21,17,22,17],[35,14,36,14],[35,16,36,16],[35,15,36,15],[33,17,34,17],[33,16,34,16],[31,14,32,14],[35,18,36,18],[35,17,36,17],[33,14,34,14],[33,15,34,15],[31,16,32,16],[39,0,40,0],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,1,40,1],[37,1,38,1],[33,5,34,5],[33,6,34,6],[33,0,34,0],[33,3,34,3],[33,1,34,1],[33,4,34,4],[35,0,36,0],[37,3,38,3],[35,3,36,3],[35,4,36,4],[37,2,38,2],[35,2,36,2],[37,0,38,0],[37,4,38,4],[33,2,34,2],[35,1,36,1],[35,6,36,6],[39,7,40,7],[39,5,40,5],[39,6,40,6],[39,8,40,8],[37,7,38,7],[35,11,36,11],[35,12,36,12],[35,13,36,13],[33,10,34,10],[33,11,34,11],[37,8,38,8],[37,5,38,5],[35,5,36,5],[37,6,38,6],[35,10,36,10],[33,7,34,7],[33,8,34,8],[35,7,36,7],[35,9,36,9],[33,9,34,9],[35,8,36,8],[37,18,38,18],[39,11,40,11],[37,9,38,9],[39,17,40,17],[39,15,40,15],[39,18,40,18],[39,16,40,16],[39,14,40,14],[37,11,38,11],[39,9,40,9],[39,10,40,10],[37,14,38,14],[37,13,38,13],[37,12,38,12],[37,15,38,15],[39,13,40,13],[37,10,38,10],[37,17,38,17],[37,16,38,16],[39,12,40,12],[41,0,42,0],[43,0,44,0],[41,7,42,7],[41,9,42,9],[41,10,42,10],[49,17,50,17],[45,17,46,17],[41,17,42,17],[41,15,42,15],[43,17,44,17],[43,16,44,16],[49,12,50,12],[41,11,42,11],[41,13,42,13],[41,12,42,12],[45,16,46,16],[45,7,46,7],[48,0,48,20],[41,14,42,14],[41,16,42,16],[41,5,42,5],[41,3,42,3],[41,1,42,1],[43,14,44,14],[57,1,57,10],[57,12,57,18],[50,0,50,8],[49,9,50,9],[49,10,50,10],[55,1,56,10],[55,12,56,18],[49,14,50,14],[52,0,53,1],[52,2,53,20],[49,18,50,18],[49,13,50,13],[49,0,49,8],[49,19,49,20],[49,11,50,11],[43,12,44,12],[45,10,46,10],[43,11,44,11],[43,18,44,18],[43,15,44,15],[43,1,44,1],[41,2,42,2],[41,8,42,8],[41,18,42,18],[43,7,44,7],[41,4,42,4],[43,2,44,2],[43,3,44,3],[43,4,44,4],[43,10,44,10],[43,5,44,5],[41,6,42,6],[45,9,46,9],[45,2,46,2],[58,0,58,2],[59,0,59,20],[54,0,54,20],[43,6,44,6],[45,0,46,0],[51,0,51,8],[47,0,47,8],[43,9,44,9],[43,13,44,13],[45,6,46,6],[43,8,44,8],[45,1,46,1],[45,5,46,5],[45,3,46,3],[45,4,46,4],[49,15,50,15],[49,16,50,16],[45,12,46,12],[45,13,46,13],[45,15,46,15],[45,8,46,8],[45,18,46,18],[45,11,46,11],[45,14,46,14],[23,4,24,4],[19,4,20,4],[21,4,22,4],[19,2,20,2],[21,3,22,3],[23,2,24,2],[19,3,20,3],[17,3,18,3],[23,3,24,3],[21,2,22,2]]}
[{"$f":"IF((_xlfn.NUMBERVALUE($K$30))>28,CONCATENATE(\"You cannot claim more than 28 hours during the first week. Please, reduce the office hours by put \",_xlfn.NUMBERVALUE(K30)-28,\" hours and talk to your supervisor.\"), IF($S$30<28,CONCATENATE(\"You entered less than 28 hours for the first week. Please, enter additional Office hours if needed -- \", 28-S30, \" hours\"),\"\"))","v":"You entered less than 28 hours for the first week. Please, enter additional Office hours if needed -- 28 hours"}]
[{"$f":"IF((_xlfn.NUMBERVALUE($K$48))>28,CONCATENATE(\"You cannot claim more than 28 hours during the first week. Please, reduce the office hours by put \",_xlfn.NUMBERVALUE($K$48)-28,\" hours and talk to your supervisor.\"), IF($S$48<28,CONCATENATE(\"You entered less than 28 hours for the first week. Please, enter additional Office hours if needed -- \", 28-$S$48, \" hours\"),\"\"))","v":"You entered less than 28 hours for the first week. Please, enter additional Office hours if needed -- 28 hours"}]
["Orange indicates that the time you entered is less than the time entered in the previous cell or you didn't enter data in the previous cell",null,null,null,null,null,null,null,null,null,null,null,"Blue indicates that you already have at least 8 hours on this day"]
["Brown indicates that you didn't enter the close hours",null,null,null,null,null,null,null,null,null,null,null,"Green indicates that you've entered more than 24 hours a day"]
["Pink indicates that you entered invalid data.  In this case you will have \"12:00 AM\" record in the cell. Please, enter data as HH:MM AM/PM",null,null,null,null,null,null,null,null,null,null,null,"Purple indicates the problem with comp time/overtime hours  "]
["Indicates that you worked 6 or more hours consecutively and need to take a break",null,null,null,null,null,null,null,null,null,null,null,"The regular hours cannot be negative. Please, check your overtime, annual, sick, comp, etc time"]
["Indicates that you need to take at least 30 minutes launch break "]
[]
[]
[null,null,null,"All boxes this color require dates in the form: H:MM AM/PM",null,null,null,null,null,null,"All boxes this color require time in decimal form."]
[]
["UNMID (not SS#):",null,null,null,null,"Employee Name:",null,null,null,null,"FTE:",null,"Pay Period:",null,"2020-01-04","To: ",{"$f":"O12+13","v":"2020-01-17"},"TimeKeep Org:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select boxes and then the arrows for additional earn codes."]
["Time Entry",null,null,null,null,null,null,null,null,"In/Out Calc","Regular","Overtime","Annual Leave","Sick Leave","Comp1 Time Earn @1.5","Paid Leave","Comp1 Time Take"," Unpaid leave","Total Hours","*Labor Override"]
[null,"Date","IN","OUT","IN","OUT","IN","OUT","Shift",null,null,null,null,null,null,null,null,null,null,"Hours","Index"]
["SAT",{"$f":"O12","v":"2020-01-04"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D16-C16<0,TEXT(C16,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D16,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D16-C16)),0)+IFERROR(SUM(IF(OR(F16-E16<0,TEXT(E16,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F16,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F16-E16)),0)+IFERROR(SUM(IF(OR(H16-G16<0,TEXT(G16,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H16,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H16-G16)),0)","v":0},{"$f":"HOUR(J16) + MINUTE(J16)/60 + SECOND(J16)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L16:R17)+_xlfn.NUMBERVALUE(K16)","v":0}]
[]
["SUN",{"$f":"O12+1","v":"2020-01-05"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D18-C18<0,TEXT(C18,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D18,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D18-C18)),0)+IFERROR(SUM(IF(OR(F18-E18<0,TEXT(E18,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F18,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F18-E18)),0)+IFERROR(SUM(IF(OR(H18-G18<0,TEXT(G18,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H18,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H18-G18)),0)","v":0},{"$f":"HOUR(J18) + MINUTE(J18)/60 + SECOND(J18)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L18:R19)+_xlfn.NUMBERVALUE(K18)","v":0}]
[]
["MON",{"$f":"O12+2","v":"2020-01-06"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D20-C20<0,TEXT(C20,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D20,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D20-C20)),0)+IFERROR(SUM(IF(OR(F20-E20<0,TEXT(E20,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F20,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F20-E20)),0)+IFERROR(SUM(IF(OR(H20-G20<0,TEXT(G20,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H20,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H20-G20)),0)","v":0},{"$f":"HOUR(J20) + MINUTE(J20)/60 + SECOND(J20)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L20:R21)+_xlfn.NUMBERVALUE(K20)","v":0}]
[]
["TUES",{"$f":"O12+3","v":"2020-01-07"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D22-C22<0,TEXT(C22,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D22,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D22-C22)),0)+IFERROR(SUM(IF(OR(F22-E22<0,TEXT(E22,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F22,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F22-E22)),0)+IFERROR(SUM(IF(OR(H22-G22<0,TEXT(G22,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H22,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H22-G22)),0)","v":0},{"$f":"HOUR(J22) + MINUTE(J22)/60 + SECOND(J22)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L22:R23)+_xlfn.NUMBERVALUE(K22)","v":0}]
[]
["WED",{"$f":"O12+4","v":"2020-01-08"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D24-C24<0,TEXT(C24,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D24,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D24-C24)),0)+IFERROR(SUM(IF(OR(F24-E24<0,TEXT(E24,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F24,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F24-E24)),0)+IFERROR(SUM(IF(OR(H24-G24<0,TEXT(G24,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H24,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H24-G24)),0)","v":0},{"$f":"HOUR(J24) + MINUTE(J24)/60 + SECOND(J24)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L24:R25)+_xlfn.NUMBERVALUE(K24)","v":0}]
[]
["THUR",{"$f":"O12+5","v":"2020-01-09"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D26-C26<0,TEXT(C26,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D26,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D26-C26)),0)+IFERROR(SUM(IF(OR(F26-E26<0,TEXT(E26,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F26,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F26-E26)),0)+IFERROR(SUM(IF(OR(H26-G26<0,TEXT(G26,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H26,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H26-G26)),0)","v":0},{"$f":"HOUR(J26) + MINUTE(J26)/60 + SECOND(J26)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L26:R27)+_xlfn.NUMBERVALUE(K26)","v":0}]
[]
["FRI",{"$f":"O12+6","v":"2020-01-10"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D28-C28<0,TEXT(C28,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D28,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D28-C28)),0)+IFERROR(SUM(IF(OR(F28-E28<0,TEXT(E28,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F28,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F28-E28)),0)+IFERROR(SUM(IF(OR(H28-G28<0,TEXT(G28,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H28,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H28-G28)),0)","v":0},{"$f":"HOUR(J28) + MINUTE(J28)/60 + SECOND(J28)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L28:R29)+_xlfn.NUMBERVALUE(K28)","v":0}]
[]
["First Week Totals:",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J29)","v":0},{"$f":"SUM(K16:K29)","v":0},{"$f":"SUM(L16:L29)","v":0},0,0,0,0,0,0,0,0]
[]
["Time Entry",null,null,null,null,null,null,null,null,"In/Out Calc","Regular","Overtime","Annual Leave","Sick Leave",{"$f":"O14","v":"Comp1 Time Earn @1.5"},{"$f":"P14","v":"Paid Leave"},{"$f":"Q14","v":"Comp1 Time Take"},{"$f":"R14","v":" Unpaid leave"},"Total Hours","*Labor Override"]
[null,"Date","IN","OUT","IN","OUT","IN","OUT","Shift",null,null,null,null,null,null,null,null,null,null,"Hours","Index"]
["SAT",{"$f":"O12+7","v":"2020-01-11"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D34-C34<0,TEXT(C34,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D34,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D34-C34)),0)+IFERROR(SUM(IF(OR(F34-E34<0,TEXT(E34,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F34,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F34-E34)),0)+IFERROR(SUM(IF(OR(H34-G34<0,TEXT(G34,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H34,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H34-G34)),0)","v":0},{"$f":"HOUR(J34) + MINUTE(J34)/60 + SECOND(J34)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L34:R35)+_xlfn.NUMBERVALUE(K34)","v":0}]
[]
["SUN",{"$f":"O12+8","v":"2020-01-12"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D36-C36<0,TEXT(C36,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D36,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D36-C36)),0)+IFERROR(SUM(IF(OR(F36-E36<0,TEXT(E36,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F36,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F36-E36)),0)+IFERROR(SUM(IF(OR(H36-G36<0,TEXT(G36,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H36,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H36-G36)),0)","v":0},{"$f":"HOUR(J36) + MINUTE(J36)/60 + SECOND(J36)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L36:R37)+_xlfn.NUMBERVALUE(K36)","v":0}]
[]
["MON",{"$f":"O12+9","v":"2020-01-13"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D38-C38<0,TEXT(C38,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D38,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D38-C38)),0)+IFERROR(SUM(IF(OR(F38-E38<0,TEXT(E38,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F38,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F38-E38)),0)+IFERROR(SUM(IF(OR(H38-G38<0,TEXT(G38,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H38,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H38-G38)),0)","v":0},{"$f":"HOUR(J38) + MINUTE(J38)/60 + SECOND(J38)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L38:R39)+_xlfn.NUMBERVALUE(K38)","v":0}]
[]
["TUES",{"$f":"O12+10","v":"2020-01-14"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D40-C40<0,TEXT(C40,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D40,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D40-C40)),0)+IFERROR(SUM(IF(OR(F40-E40<0,TEXT(E40,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F40,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F40-E40)),0)+IFERROR(SUM(IF(OR(H40-G40<0,TEXT(G40,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H40,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H40-G40)),0)","v":0},{"$f":"HOUR(J40) + MINUTE(J40)/60 + SECOND(J40)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L40:R41)+_xlfn.NUMBERVALUE(K40)","v":0}]
[]
["WED",{"$f":"O12+11","v":"2020-01-15"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D42-C42<0,TEXT(C42,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D42,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D42-C42)),0)+IFERROR(SUM(IF(OR(F42-E42<0,TEXT(E42,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F42,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F42-E42)),0)+IFERROR(SUM(IF(OR(H42-G42<0,TEXT(G42,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H42,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H42-G42)),0)","v":0},{"$f":"HOUR(J42) + MINUTE(J42)/60 + SECOND(J42)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L42:R43)+_xlfn.NUMBERVALUE(K42)","v":0}]
[]
["THUR",{"$f":"O12+12","v":"2020-01-16"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D44-C44<0,TEXT(C44,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D44,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D44-C44)),0)+IFERROR(SUM(IF(OR(F44-E44<0,TEXT(E44,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F44,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F44-E44)),0)+IFERROR(SUM(IF(OR(H44-G44<0,TEXT(G44,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H44,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H44-G44)),0)","v":0},{"$f":"HOUR(J44) + MINUTE(J44)/60 + SECOND(J44)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L44:R45)+_xlfn.NUMBERVALUE(K44)","v":0}]
[]
["FRI",{"$f":"O12+13","v":"2020-01-17"},null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(IF(OR(D46-C46<0,TEXT(C46,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(D46,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",D46-C46)),0)+IFERROR(SUM(IF(OR(F46-E46<0,TEXT(E46,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(F46,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",F46-E46)),0)+IFERROR(SUM(IF(OR(H46-G46<0,TEXT(G46,\"hh:mm AM/PM\")=\"12:00 AM\",TEXT(H46,\"hh:mm AM/PM\")=\"12:00 AM\"),\"0:00\",H46-G46)),0)","v":0},{"$f":"HOUR(J46) + MINUTE(J46)/60 + SECOND(J46)/3600","v":0},null,null,null,null,null,null,null,{"$f":"SUM(L46:R47)+_xlfn.NUMBERVALUE(K46)","v":0}]
[]
["Second Week Totals:",null,null,null,null,null,null,null,null,{"$f":"SUM(J34:J47)","v":0},{"$f":"SUM(K34:K47)","v":0},{"$f":"SUM(L34:L47)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,"In/Out Calc","Regular","Overtime","Annual Leave","Sick Leave",{"$f":"O14","v":"Comp1 Time Earn @1.5"},{"$f":"P14","v":"Paid Leave"},{"$f":"Q14","v":"Comp1 Time Take"},{"$f":"R14","v":" Unpaid leave"},"Total Hours","*Labor Override"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours","Index"]
["Grand Totals",null,null,null,null,null,null,null,null,{"$f":"SUM(J30+J48)","v":0},{"$f":"SUM(K30+K48)","v":0},0,0,0,0,0,0,0,0,0]
["Comments:"]
[]
["I agree with the hours worked and time taken as shown on this Timesheet."]
[]
[]
[null,"Employee Signature/Date",null,null,null,null,null,null,null,null,null,null,"Supervisor Signature/Date"]
["Last Updated: 04/03/2019"]
["\"The accuracy of time reporting is the responsibility of each employee and their supervisor.  Failure to report time accurately and in compliance with the Fair Labor Standards Act and University Policy may result in penalties to the University and/or disciplinary action to the employee(s).  To assist you in understanding these requirements, informational courses are available in Learning Central, under \"Required University Training\" (Leaders and Timekeepers), and \"Workplace Effectiveness Skills\" (Staff)."]

{"sheet":"Sheet1","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["2019-12-21",1,{"$f":"DATE(YEAR($A$1),MONTH($A$1),DAY($A$1))+14*B1","v":"2020-01-04"}]
[null,2,{"$f":"DATE(YEAR($A$1),MONTH($A$1),DAY($A$1))+14*B2","v":"2020-01-18"}]
[null,3,"2020-02-01"]
[null,4,"2020-02-15"]
[null,5,"2020-02-29"]
[null,6,"2020-03-14"]
[null,7,"2020-03-28"]
[null,8,"2020-04-11"]
[null,9,"2020-04-25"]
[null,10,"2020-05-09"]
[null,11,"2020-05-23"]
[null,12,"2020-06-06"]
[null,13,"2020-06-20"]
[null,14,"2020-07-04"]
[null,15,"2020-07-18"]
[null,16,"2020-08-01"]
[null,17,"2020-08-15"]
[null,18,"2020-08-29"]
[null,19,"2020-09-12"]
[null,20,"2020-09-26"]
[null,21,"2020-10-10"]
[null,22,"2020-10-24"]
[null,23,"2020-11-07"]
[null,24,"2020-11-21"]
[null,25,"2020-12-05"]
[null,26,"2020-12-19"]
[null,27,"2021-01-02"]
[null,28,"2021-01-16"]
[null,29,"2021-01-30"]
[null,30,"2021-02-13"]
[null,31,"2021-02-27"]

{"sheet":"Sheet2","index":2,"n_rows":125,"n_cols":5,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[" ","Pay period dates","Times","Time"]
["> 40 Hrs per Wk @1.0 rate","2014-01-11",null,0,0]
["Catastrophic Leave",{"$f":"B2+14","v":"2014-01-25"},"00:00:00",0.5,24]
["Clinical Teaching Asso @5","2014-02-08","00:30:00",1]
["Comp1 Time Earn @1.0","2014-02-22","01:00:00",1.5]
["Comp1 Time Earn @1.5","2014-03-08","01:30:00",2]
["Comp1 Time Pay Out @1.0","2014-03-22","02:00:00",2.5]
["Comp1 Time Taken @1.0","2014-04-05","02:30:00",3]
["Comp2 Time Pay Out @1.0","2014-04-19","03:00:00",3.5]
["Comp2 Time Earn @1.0","2014-05-03","03:30:00",4]
["Comp2 Time Earn @1.5","2014-05-17","04:00:00",4.5]
["Comp2 Time Taken @1.0","2014-05-31","04:30:00",5]
["Leave Without Pay","2014-06-14","05:00:00",5.5]
["Lobo@10","2014-06-28","05:30:00",6]
["Lobo@15","2014-07-12","06:00:00",6.5]
["Lobo@17","2014-07-26","06:30:00",7]
["Lobo@19","2014-08-09","07:00:00",7.5]
["Med Oncall Drive @30","2014-08-23","07:30:00",8]
["Med Oncall holiday @150","2014-09-06","08:00:00",8.5]
["Med Oncall Temp Earnings","2014-09-20","08:30:00",9]
["Med Interpreters","2014-10-04","09:00:00",9.5]
["MO-Peer Review @ 150","2014-10-18","09:30:00",10]
["OMI Autopsy @85","2014-11-01","10:00:00",10.5]
["OMI Field External @100","2014-11-15","10:30:00",11]
["OMIJT @65","2014-11-29","11:00:00",11.5]
["Pager Stand By @15","2014-12-13","11:30:00",12]
["Pager Stand-by $1.25","2014-12-27","12:00:00",12.5]
["Pager Stand-by $2.00","2015-01-10","12:30:00",13]
["Pager Stand-by $2.50",{"$f":"B28+14","v":"2015-01-24"},"13:00:00",13.5]
["Pager Stand-by $3.00","2015-02-07","13:30:00",14]
["Pager Stand-by $3.50","2015-02-21","14:00:00",14.5]
["Pager Stand-by $4.00","2015-03-07","14:30:00",15]
["Pager Stand-by Reg","2015-03-21","15:00:00",15.5]
["Paid Leave","2015-04-04","15:30:00",16]
[null,"2015-04-18","16:00:00",16.5]
[null,"2015-05-02","16:30:00",17]
[null,"2015-05-16","17:00:00",17.5]
[null,"2015-05-30","17:30:00",18]
[null,"2015-06-13","18:00:00",18.5]
[null,"2015-06-27","18:30:00",19]
[null,"2015-07-11","19:00:00",19.5]
[null,"2015-07-25","19:30:00",20]
[null,"2015-08-08","20:00:00",20.5]
[null,"2015-08-22","20:30:00",21]
[null,"2015-09-05","21:00:00",21.5]
[null,"2015-09-19","21:30:00",22]
[null,"2015-10-03","22:00:00",22.5]
[null,"2015-10-17","22:30:00",23]
[null,"2015-10-31","23:00:00",23.5]
[null,"2015-11-14","23:30:00",24]
[null,"2015-11-28","23:59:00"]
[null,"2015-12-12"]
[null,"2015-12-26"]
[null,"2016-01-09"]
[null,"2016-01-23"]
[null,"2016-02-06"]
[null,"2016-02-20"]
[null,"2016-03-05"]
[null,"2016-03-19"]
[null,"2016-04-02"]
[null,"2016-04-16"]
[null,"2016-04-30"]
[null,"2016-05-14"]
[null,"2016-05-28"]
[null,"2016-06-11"]
[null,"2016-06-25"]
[null,{"$f":"B66+14","v":"2016-07-09"}]
[null,"2016-07-23"]
[null,"2016-08-06"]
[null,"2016-08-20"]
[null,"2016-09-03"]
[null,"2016-09-17"]
[null,"2016-10-01"]
[null,"2016-10-15"]
[null,"2016-10-29"]
[null,"2016-11-12"]
[null,"2016-11-26"]
[null,"2016-12-10"]
[null,"2016-12-24"]
[null,"2017-01-07"]
[null,"2017-01-21"]
[null,"2017-02-04"]
[null,"2017-02-18"]
[null,"2017-03-04"]
[null,"2017-03-18"]
[null,"2017-04-01"]
[null,"2017-04-15"]
[null,"2017-04-29"]
[null,"2017-05-13"]
[null,"2017-05-27"]
[null,"2017-06-10"]
[null,"2017-06-24"]
[null,"2017-07-08"]
[null,"2017-07-22"]
[null,"2017-08-05"]
[null,"2017-08-19"]
[null,"2017-09-02"]
[null,"2017-09-16"]
[null,"2017-09-30"]
[null,"2017-10-14"]
[null,"2017-10-28"]
[null,"2017-11-11"]
[null,"2017-11-25"]
[null,"2017-12-09"]
[null,"2017-12-23"]
[null,"2018-01-06"]
[null,"2018-01-20"]
[null,"2018-02-03"]
[null,"2018-02-17"]
[null,"2018-03-03"]
[null,"2018-03-17"]
[null,"2018-03-31"]
[null,"2018-04-14"]
[null,"2018-04-28"]
[null,"2018-05-12"]
[null,"2018-05-26"]
[null,"2018-06-09"]
[null,"2018-06-23"]
[null,"2018-07-07"]
[null,"2018-07-21"]
[null,"2018-08-04"]
[null,"2018-08-18"]
[null,"2018-09-01"]
[null,"2018-09-15"]
[null,{"$f":"B124+14","v":"2018-09-29"}]