{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Timecard with Breaks"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Timecard with Breaks","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[1,2,1,6],[1,8,1,11],[11,1,11,4],[12,1,12,4],[13,1,13,4],[15,1,15,2],[15,4,15,7],[15,9,15,11],[17,1,17,2],[17,4,17,7],[17,9,17,11],[20,2,20,10]]}
[null,"TIMECARD TEMPLATE WITH BREAKS"]
[null,"Employee:",{"$nulls":5},"Week of:","2018-01-01"]
[]
[null,"DATE","START TIME","TOTAL BREAK TIME IN MINUTES","FINISH TIME","REGULAR HRS","OVERTIME HRS","SICK","VACATION","HOLIDAY","OTHER","TOTAL HOURS"]
[null,{"$f":"I2","v":"2018-01-01"},"08:00:00",60,"18:00:00",8,1,{"$nulls":4},{"$f":"SUM(F5:K5)","v":9}]
[null,{"$f":"I2+1","v":"2018-01-02"},{"$nulls":8},8,8]
[null,{"$f":"I2+2","v":"2018-01-03"},"08:00:00",0,"16:00:00",8,{"$nulls":5},8]
[null,{"$f":"I2+3","v":"2018-01-04"},"08:00:00",0,"16:00:00",8,{"$nulls":5},8]
[null,{"$f":"I2+4","v":"2018-01-05"},"08:00:00",0,"18:00:00",8,2,{"$nulls":4},10]
[null,{"$f":"I2+5","v":"2018-01-06"},{"$nulls":9},0]
[null,{"$f":"I2+6","v":"2018-01-07"},{"$nulls":9},0]
[null,"TOTAL HOURS",{"$nulls":3},{"$f":"SUM(F5:F11)","v":32},{"$f":"SUM(G5:G11)","v":3},0,0,0,8,43]
[null,"RATE PER HOUR",{"$nulls":3},{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"}]
[null,"TOTAL PAY",{"$nulls":3},{"$f":"F13*F12","v":{"v":640,"d":"$640.00"}},{"v":90,"d":"$90.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":160,"d":"$160.00"},{"$f":"SUM(F14:K14)","v":{"v":890,"d":"$890.00"}}]
[]
[null,"Employee Signature:",{"$nulls":6},"Date:"]
[]
[null,"Manager Signature:",{"$nulls":6},"Date:"]
[]
[]
[null,null,"CLICK HERE TO CREATE TIMECARD TEMPLATES WITH BREAKS IN SMARTSHEET"]