{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Timesheet"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Timesheet","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[1,1,1,4],[2,1,2,4]]}
[]
[null,"TIMESHEET"]
[null,"Company Name",{"$nulls":5}," "]
[]
[null,"Employee Details",null,null,"Manager Details"]
[null,"Enter Employee Name",null,null,"Enter Manager Name"]
[null,"Enter Employee's Phone No",null,null,"Enter Manager's Phone No"]
[null,"Total Work Week Hours",null,null,"Total Hours Worked"]
[null,40,null,null,{"$f":"SUM(Table_Timesheet[Hours Worked])","v":{"v":0,"d":"0.00"}}]
[null,"Overtime Hours",null,null,"Regular Hours"]
[null,{"$f":"TotalHoursWorked-RegularHours","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(TotalHoursWorked<=WorkWeekHours,TotalHoursWorked,WorkWeekHours)","v":{"v":0,"d":"0.00"}}]
[null,"Timesheet Period"]
[null,"Period Start",null,null,"Period End"]
[null,"Enter Start Date",null,null,"Enter End Date"]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out","Hours Worked"]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(COUNT(Table_Timesheet[[#This Row],[Time In]:[Time Out]])=4,(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Lunch End]]+Table_Timesheet[[#This Row],[Lunch Start]]-Table_Timesheet[[#This Row],[Time In]],IF(AND(LEN(Table_Timesheet[[#This Row],[Time In]])<>0,LEN(Table_Timesheet[[#This Row],[Time Out]])<>0),(IF(Table_Timesheet[[#This Row],[Time Out]]<Table_Timesheet[[#This Row],[Time In]],1,0)+Table_Timesheet[[#This Row],[Time Out]])-Table_Timesheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]