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

{"sheet":"Time Sheet","index":0,"n_rows":15,"n_cols":7,"rows_kept":15}
[null,"Time Sheet"]
[null,"Employee Details:","Name","Email","Phone"]
[null,"Manager Details:","Name"]
[null,"Period Start Date","Period End Date"]
[null,"Total Work \nWeek Hours","Total Hours\nWorked","Regular Hours","Overtime Hours"]
[null,{"v":40,"d":"40.00"},{"$f":"SUBTOTAL(109,TimeSheet[Hours Worked])","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(C6<=WorkweekHours,C6,WorkweekHours),\"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(C6-D6, \"\")","v":{"v":0,"d":"0.00"}}]
[null,"Date(s)","Time In","Lunch Start","Lunch End","Time Out","Hours Worked"]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[Time In]:[Time Out]])=4,(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Lunch End]]+TimeSheet[[#This Row],[Lunch Start]]-TimeSheet[[#This Row],[Time In]],IF(AND(LEN(TimeSheet[[#This Row],[Time In]])<>0,LEN(TimeSheet[[#This Row],[Time Out]])<>0),(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[Time In]:[Time Out]])=4,(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Lunch End]]+TimeSheet[[#This Row],[Lunch Start]]-TimeSheet[[#This Row],[Time In]],IF(AND(LEN(TimeSheet[[#This Row],[Time In]])<>0,LEN(TimeSheet[[#This Row],[Time Out]])<>0),(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[Time In]:[Time Out]])=4,(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Lunch End]]+TimeSheet[[#This Row],[Lunch Start]]-TimeSheet[[#This Row],[Time In]],IF(AND(LEN(TimeSheet[[#This Row],[Time In]])<>0,LEN(TimeSheet[[#This Row],[Time Out]])<>0),(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[Time In]:[Time Out]])=4,(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Lunch End]]+TimeSheet[[#This Row],[Lunch Start]]-TimeSheet[[#This Row],[Time In]],IF(AND(LEN(TimeSheet[[#This Row],[Time In]])<>0,LEN(TimeSheet[[#This Row],[Time Out]])<>0),(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[null,"Date","Time In","Lunch Start","Lunch End","Time Out",{"$f":"IFERROR(IF(COUNT(TimeSheet[[#This Row],[Time In]:[Time Out]])=4,(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Lunch End]]+TimeSheet[[#This Row],[Lunch Start]]-TimeSheet[[#This Row],[Time In]],IF(AND(LEN(TimeSheet[[#This Row],[Time In]])<>0,LEN(TimeSheet[[#This Row],[Time Out]])<>0),(IF(TimeSheet[[#This Row],[Time Out]]<TimeSheet[[#This Row],[Time In]],1,0)+TimeSheet[[#This Row],[Time Out]])-TimeSheet[[#This Row],[Time In]],0))*24,0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"Spreadsheet Templates - http://www.spreadsheettemplates.info/"]