{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Overtime Calculator","DATA","- Disclaimer -"],"not_rendered":{"images":1,"external_links":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Overtime Calculator","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"merged":[[1,1,1,3],[1,5,1,6],[1,7,1,8],[2,1,2,3],[2,5,2,6],[2,7,2,8],[4,1,5,2],[4,7,4,8],[5,7,5,8],[7,1,8,2],[9,1,10,3],[9,4,9,8],[10,6,10,8],[46,1,46,8]]}
[null,"OVERTIME CALCULATOR AND ANALYSIS TEMPLATE"]
[null,"EMPLOYEE NAME",null,null,"EMPLOYEE ID","DEPARTMENT",null,"MANAGER"]
[]
[]
[null,"Select date from drop-down menus for Year, Month, Date, and \nWeekend fields.",null,"YEAR","MONTH","DATE","WEEKEND","        Check box if Weekends \n        are paid at overtime rate"]
[{"$nulls":3},2025,"June",1,"Sat & Sun","  <--- Select designated Weekend Days"]
[]
[null,"Enter data for Start Time, Regular Hours, Regular Pay, and Overtime Pay.   ",null,"START \nTIME","REGULAR \nHOURS*","REGULAR PAY\nhourly rate","OVERTIME PAY\nhourly rate"]
[{"$nulls":3},"08:00:00",{"v":9,"d":"9.00"},{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"}]
[null,"Enter Start, End, and Break \nTimes, below.  \n\nDay and Date and Calculations will automatically populate.  ",null,null,"*When designating \"Regular Hours,\" build in standard break times. For example, if a standard shift begins at 8am and ends at 4:30pm with a half-hour break, set hours to: 8.5\nif a standard shift begins at 8am and ends at 5pm with an hour break, set hours to: 9.0"]
[{"$nulls":6},"C A L C U L A T I O N S\ndo not alter fields"]
[null,"DAY","DATE","START \nTIME","END \nTIME","BREAK TIME\nin hours","REGULAR \nHOURS","OVERTIME \nHOURS","TOTAL \nPAY"]
[null,{"$f":"DATE($D$6,MATCH($E$6,DATA!$D$3:$D$14,0),'Overtime Calculator'!$F$6)","v":"2025-06-01"},{"$f":"DATE($D$6,MATCH($E$6,DATA!$D$3:$D$14,0),'Overtime Calculator'!$F$6)","v":"2025-06-01"},{"$nulls":3},{"$f":"IFERROR(IF(AND(D13<>\"\",E13<>\"\"),IF(D13>$D$9+TIME($E$9,($E$9-INT($E$9))*60,0),0,IF(E13>$D$9+TIME($E$9,($E$9-INT($E$9))*60,0),MIN(TIME($E$9,($E$9-INT($E$9))*60,0),($D$9+TIME($E$9,($E$9-INT($E$9))*60,0)-D13)),MIN(IF((E13-$D$9)<0,0,(E13-$D$9)),(E13-D13))))*24,\"\")-F13,\"\")","v":""},{"$f":"IF(AND(D13<>\"\",E13<>\"\"),((IF(D13<$D$9,MIN($D$9-D13,E13-D13),0)+IF(E13>$D$9+TIME($E$9,($E$9-INT($E$9))*60,0),MIN((E13-$D$9-TIME($E$9,($E$9-INT($E$9))*60,0)),(E13-D13)),0))*24),\"\")","v":""},{"$f":"IFERROR(G13*IF(AND(ISNUMBER(SEARCH(TEXT(B13,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H13*$G$9,\"\")","v":""}]
[null,{"$f":"B13+1","v":"2025-06-02"},{"$f":"C13+1","v":"2025-06-02"},{"$nulls":3},"","",{"$f":"IFERROR(G14*IF(AND(ISNUMBER(SEARCH(TEXT(B14,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H14*$G$9,\"\")","v":""}]
[null,{"$f":"B14+1","v":"2025-06-03"},"2025-06-03",{"$nulls":3},"","",{"$f":"IFERROR(G15*IF(AND(ISNUMBER(SEARCH(TEXT(B15,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H15*$G$9,\"\")","v":""}]
[null,"2025-06-04","2025-06-04",{"$nulls":3},"","",{"$f":"IFERROR(G16*IF(AND(ISNUMBER(SEARCH(TEXT(B16,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H16*$G$9,\"\")","v":""}]
[null,"2025-06-05","2025-06-05",{"$nulls":3},"","",{"$f":"IFERROR(G17*IF(AND(ISNUMBER(SEARCH(TEXT(B17,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H17*$G$9,\"\")","v":""}]
[null,"2025-06-06","2025-06-06",{"$nulls":3},"","",{"$f":"IFERROR(G18*IF(AND(ISNUMBER(SEARCH(TEXT(B18,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H18*$G$9,\"\")","v":""}]
[null,"2025-06-07","2025-06-07",{"$nulls":3},"","",{"$f":"IFERROR(G19*IF(AND(ISNUMBER(SEARCH(TEXT(B19,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H19*$G$9,\"\")","v":""}]
[null,"2025-06-08","2025-06-08",{"$nulls":3},"","",{"$f":"IFERROR(G20*IF(AND(ISNUMBER(SEARCH(TEXT(B20,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H20*$G$9,\"\")","v":""}]
[null,"2025-06-09","2025-06-09",{"$nulls":3},"","",{"$f":"IFERROR(G21*IF(AND(ISNUMBER(SEARCH(TEXT(B21,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H21*$G$9,\"\")","v":""}]
[null,"2025-06-10","2025-06-10",{"$nulls":3},"","",{"$f":"IFERROR(G22*IF(AND(ISNUMBER(SEARCH(TEXT(B22,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H22*$G$9,\"\")","v":""}]
[null,"2025-06-11","2025-06-11",{"$nulls":3},"","",{"$f":"IFERROR(G23*IF(AND(ISNUMBER(SEARCH(TEXT(B23,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H23*$G$9,\"\")","v":""}]
[null,"2025-06-12","2025-06-12",{"$nulls":3},"","",{"$f":"IFERROR(G24*IF(AND(ISNUMBER(SEARCH(TEXT(B24,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H24*$G$9,\"\")","v":""}]
[null,"2025-06-13","2025-06-13",{"$nulls":3},"","",{"$f":"IFERROR(G25*IF(AND(ISNUMBER(SEARCH(TEXT(B25,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H25*$G$9,\"\")","v":""}]
[null,"2025-06-14","2025-06-14",{"$nulls":3},"","",{"$f":"IFERROR(G26*IF(AND(ISNUMBER(SEARCH(TEXT(B26,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H26*$G$9,\"\")","v":""}]
[null,{"$f":"B26+1","v":"2025-06-15"},"2025-06-15",{"$nulls":3},"","",{"$f":"IFERROR(G27*IF(AND(ISNUMBER(SEARCH(TEXT(B27,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H27*$G$9,\"\")","v":""}]
[null,{"$f":"B27+1","v":"2025-06-16"},"2025-06-16",{"$nulls":3},"","",{"$f":"IFERROR(G28*IF(AND(ISNUMBER(SEARCH(TEXT(B28,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H28*$G$9,\"\")","v":""}]
[null,{"$f":"B28+1","v":"2025-06-17"},"2025-06-17",{"$nulls":3},"","",{"$f":"IFERROR(G29*IF(AND(ISNUMBER(SEARCH(TEXT(B29,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H29*$G$9,\"\")","v":""}]
[null,{"$f":"B29+1","v":"2025-06-18"},"2025-06-18",{"$nulls":3},"","",{"$f":"IFERROR(G30*IF(AND(ISNUMBER(SEARCH(TEXT(B30,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H30*$G$9,\"\")","v":""}]
[null,{"$f":"B30+1","v":"2025-06-19"},"2025-06-19",{"$nulls":3},"","",{"$f":"IFERROR(G31*IF(AND(ISNUMBER(SEARCH(TEXT(B31,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H31*$G$9,\"\")","v":""}]
[null,{"$f":"B31+1","v":"2025-06-20"},"2025-06-20",{"$nulls":3},"","",{"$f":"IFERROR(G32*IF(AND(ISNUMBER(SEARCH(TEXT(B32,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H32*$G$9,\"\")","v":""}]
[null,{"$f":"B32+1","v":"2025-06-21"},"2025-06-21",{"$nulls":3},"","",{"$f":"IFERROR(G33*IF(AND(ISNUMBER(SEARCH(TEXT(B33,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H33*$G$9,\"\")","v":""}]
[null,{"$f":"B33+1","v":"2025-06-22"},"2025-06-22",{"$nulls":3},"","",{"$f":"IFERROR(G34*IF(AND(ISNUMBER(SEARCH(TEXT(B34,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H34*$G$9,\"\")","v":""}]
[null,{"$f":"B34+1","v":"2025-06-23"},"2025-06-23",{"$nulls":3},"","",{"$f":"IFERROR(G35*IF(AND(ISNUMBER(SEARCH(TEXT(B35,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H35*$G$9,\"\")","v":""}]
[null,{"$f":"B35+1","v":"2025-06-24"},"2025-06-24",{"$nulls":3},"","",{"$f":"IFERROR(G36*IF(AND(ISNUMBER(SEARCH(TEXT(B36,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H36*$G$9,\"\")","v":""}]
[null,{"$f":"B36+1","v":"2025-06-25"},"2025-06-25",{"$nulls":3},"","",{"$f":"IFERROR(G37*IF(AND(ISNUMBER(SEARCH(TEXT(B37,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H37*$G$9,\"\")","v":""}]
[null,{"$f":"B37+1","v":"2025-06-26"},"2025-06-26",{"$nulls":3},"","",{"$f":"IFERROR(G38*IF(AND(ISNUMBER(SEARCH(TEXT(B38,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H38*$G$9,\"\")","v":""}]
[null,{"$f":"B38+1","v":"2025-06-27"},"2025-06-27",{"$nulls":3},"","",{"$f":"IFERROR(G39*IF(AND(ISNUMBER(SEARCH(TEXT(B39,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H39*$G$9,\"\")","v":""}]
[null,{"$f":"B39+1","v":"2025-06-28"},"2025-06-28",{"$nulls":3},"","",{"$f":"IFERROR(G40*IF(AND(ISNUMBER(SEARCH(TEXT(B40,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H40*$G$9,\"\")","v":""}]
[null,{"$f":"B40+1","v":"2025-06-29"},"2025-06-29",{"$nulls":3},"","",{"$f":"IFERROR(G41*IF(AND(ISNUMBER(SEARCH(TEXT(B41,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H41*$G$9,\"\")","v":""}]
[null,"2025-06-30","2025-06-30",{"$nulls":3},"","",{"$f":"IFERROR(G42*IF(AND(ISNUMBER(SEARCH(TEXT(B42,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H42*$G$9,\"\")","v":""}]
[null,"2025-07-01","2025-07-01",{"$nulls":3},"","",{"$f":"IFERROR(G43*IF(AND(ISNUMBER(SEARCH(TEXT(B43,\"ddd\"),$G$6)),DATA!$J$3),$G$9,$F$9)+H43*$G$9,\"\")","v":""}]
[{"$nulls":5},"BREAK TIME\nin hours","REGULAR \nHOURS","OVERTIME \nHOURS","TOTAL \nPAY"]
[{"$nulls":4},"OVERVIEW",{"$f":"SUM(F13:F41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G13:G41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H13:H41)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I13:I41)","v":0}]
[]
[null,"CLICK HERE TO CREATE IN SMARTSHEET"]

{"sheet":"DATA","index":1,"n_rows":33,"n_cols":10,"rows_kept":33}
[null,"OVERTIME CALCULATOR AND ANALYSIS DATA"]
[null,"YEAR",null,"MONTH",null,"DAY",null,"WEEKENDS",null,"PAID WEEKEND CHECK BOX"]
[null,2019,null,"January",null,1,null,"No Weekend",null,true]
[null,2020,null,"February",null,2,null,"Sat & Sun"]
[null,2021,null,"March",null,3,null,"Sun & Mon"]
[null,2022,null,"April",null,4,null,"Mon & Tue"]
[null,2023,null,"May",null,5,null,"Tue & Wed"]
[null,2024,null,"June",null,6,null,"Wed & Thu"]
[null,2025,null,"July",null,7,null,"Thu & Fri"]
[null,2026,null,"August",null,8,null,"Fri & Sat"]
[null,2027,null,"September",null,9,null,"Mon Only"]
[null,2028,null,"October",null,10,null,"Tue Only"]
[null,2029,null,"November",null,11,null,"Wed Only"]
[null,2030,null,"December",null,12,null,"Thu Only"]
[{"$nulls":5},13,null,"Fri Only"]
[{"$nulls":5},14,null,"Sat Only"]
[{"$nulls":5},15,null,"Sun Only"]
[{"$nulls":5},16]
[{"$nulls":5},17]
[{"$nulls":5},18]
[{"$nulls":5},19]
[{"$nulls":5},20]
[{"$nulls":5},21]
[{"$nulls":5},22]
[{"$nulls":5},23]
[{"$nulls":5},24]
[{"$nulls":5},25]
[{"$nulls":5},26]
[{"$nulls":5},27]
[{"$nulls":5},28]
[{"$nulls":5},29]
[{"$nulls":5},30]
[{"$nulls":5},31]

{"sheet":"- Disclaimer -","index":2,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"Any articles, templates, or information provided by Smartsheet on the website are for reference only. While we strive to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability, or availability with respect to the website or the information, articles, templates, or related graphics contained on the website. Any reliance you place on such information is therefore strictly at your own risk. "]