{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Operator","Fraction","Direct","TIME","TIME,HOUR,MINUTE","TEXT","MOD","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Employee Time Tracker"]
[]
[null,"Name","In Time","Out Time","Lunch Time"]
[null,"Robin","08:30:00","16:30:00",30]
[null,"Mary","08:02:00","16:48:00",30]
[null,"Jones","09:04:00","17:00:00",30]
[null,"Susan","08:45:00","16:50:00",30]
[null,"James","08:23:00","17:06:00",30]
[null,"Frank","09:20:00","17:50:00",30]
[null,"Jennifer","08:10:00","17:00:00",30]
[null,"Thomas","09:00:00","15:40:00",30]
[null,"Mark","08:38:00","16:50:00",30]
[null,"Sandra","09:00:00","17:00:00",30]

{"sheet":"Operator","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Using Arithmetic Operator",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},"00:30:00",{"$f":"E5-F5","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},"00:30:00",{"$f":"E6-F6","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00","00:30:00","07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00","00:30:00","07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00","00:30:00","08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00","00:30:00","08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00","00:30:00","08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00","00:30:00","06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00","00:30:00","07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00","00:30:00","07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"Fraction","index":2,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Utilizing Fraction of a Day",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},30,{"$f":"E5-F5/1440","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},30,{"$f":"E6-F6/1440","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00",30,"07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00",30,"07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00",30,"08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00",30,"08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00",30,"08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00",30,"06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00",30,"07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00",30,"07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"Direct","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Directly Subtract 30 Minutes from a Time",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},30,{"$f":"E5-\"00:30\"","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},30,{"$f":"E6-\"00:30\"","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00",30,"07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00",30,"07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00",30,"08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00",30,"08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00",30,"08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00",30,"06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00",30,"07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00",30,"07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"TIME","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Inserting TIME Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},30,{"$f":"E5-TIME(0,F5,0)","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},30,{"$f":"E6-TIME(0,F6,0)","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00",30,"07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00",30,"07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00",30,"08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00",30,"08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00",30,"08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00",30,"06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00",30,"07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00",30,"07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"TIME,HOUR,MINUTE","index":5,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Combining TIME, HOUR, MINUTE Functions",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},30,{"$f":"TIME(HOUR(E5),MINUTE(E5)-F5,SECOND(E5))","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},30,{"$f":"TIME(HOUR(E6),MINUTE(E6)-F6,SECOND(E6))","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00",30,"07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00",30,"07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00",30,"08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00",30,"08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00",30,"08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00",30,"06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00",30,"07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00",30,"07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"TEXT","index":6,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Employing TEXT Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},"00:30:00",{"$f":"TEXT(E5-F5,\"h:mm\")","v":"7:30"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},"00:30:00",{"$f":"TEXT(E6-F6,\"h:mm\")","v":"8:16"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00","00:30:00","7:26",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00","00:30:00","7:35",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00","00:30:00","8:13",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00","00:30:00","8:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00","00:30:00","8:20",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00","00:30:00","6:10",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00","00:30:00","7:42",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00","00:30:00","7:30",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"MOD","index":7,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Implementing MOD Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time",null,null,null,"Name","In Time","Out Time","Total Time","Lunch Time","Total Work Time"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"},30,{"$f":"MOD(E5-F5/1440,1)","v":"07:30:00"},null,null,null,"Robin","08:30:00","16:30:00",null,30]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"},30,{"$f":"MOD(E6-F6/1440,1)","v":"08:16:00"},null,null,null,"Mary","08:02:00","16:48:00",null,30]
[null,"Jones","09:04:00","17:00:00","07:56:00",30,"07:26:00",null,null,null,"Jones","09:04:00","17:00:00",null,30]
[null,"Susan","08:45:00","16:50:00","08:05:00",30,"07:35:00",null,null,null,"Susan","08:45:00","16:50:00",null,30]
[null,"James","08:23:00","17:06:00","08:43:00",30,"08:13:00",null,null,null,"James","08:23:00","17:06:00",null,30]
[null,"Frank","09:20:00","17:50:00","08:30:00",30,"08:00:00",null,null,null,"Frank","09:20:00","17:50:00",null,30]
[null,"Jennifer","08:10:00","17:00:00","08:50:00",30,"08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00",null,30]
[null,"Thomas","09:00:00","15:40:00","06:40:00",30,"06:10:00",null,null,null,"Thomas","09:00:00","15:40:00",null,30]
[null,"Mark","08:38:00","16:50:00","08:12:00",30,"07:42:00",null,null,null,"Mark","08:38:00","16:50:00",null,30]
[null,"Sandra","09:00:00","17:00:00","08:00:00",30,"07:30:00",null,null,null,"Sandra","09:00:00","17:00:00",null,30]

{"sheet":"VBA","index":8,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","In Time","Out Time","Lunch Time","Total Time",null,null,null,"Name","In Time","Out Time","Lunch Time","Total Time"]
[null,"Robin","08:30:00","16:30:00","00:30:00","07:30:00",null,null,null,"Robin","08:30:00","16:30:00","00:30:00"]
[null,"Mary","08:02:00","16:48:00","00:30:00","08:16:00",null,null,null,"Mary","08:02:00","16:48:00","00:30:00"]
[null,"Jones","09:04:00","17:00:00","00:30:00","07:26:00",null,null,null,"Jones","09:04:00","17:00:00","00:30:00"]
[null,"Susan","08:45:00","16:50:00","00:30:00","07:35:00",null,null,null,"Susan","08:45:00","16:50:00","00:30:00"]
[null,"James","08:23:00","17:06:00","00:30:00","08:13:00",null,null,null,"James","08:23:00","17:06:00","00:30:00"]
[null,"Frank","09:20:00","17:50:00","00:30:00","08:00:00",null,null,null,"Frank","09:20:00","17:50:00","00:30:00"]
[null,"Jennifer","08:10:00","17:00:00","00:30:00","08:20:00",null,null,null,"Jennifer","08:10:00","17:00:00","00:30:00"]
[null,"Thomas","09:00:00","15:40:00","00:30:00","06:10:00",null,null,null,"Thomas","09:00:00","15:40:00","00:30:00"]
[null,"Mark","08:38:00","16:50:00","00:30:00","07:42:00",null,null,null,"Mark","08:38:00","16:50:00","00:30:00"]
[null,"Sandra","09:00:00","17:00:00","00:30:00","07:30:00",null,null,null,"Sandra","09:00:00","17:00:00","00:30:00"]