{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Subtraction","Hours, Minutes and Seconds","TEXT Function","Time crosses Midnight","Time crosses Midnight (2)","Date and Time","VBA","DATEDIF"],"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":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employee Time Sheet"]
[]
[null,"Name","In Time","Out Time"]
[null,"Robin","08:30:00","16:30:00"]
[null,"Mary","08:02:00","16:48:00"]
[null,"Jones","09:04:00","17:00:00"]
[null,"Susan","08:45:00","16:50:00"]
[null,"James","08:23:00","17:06:00"]
[null,"Frank","09:20:00","17:50:00"]
[null,"Jennifer","08:10:00","17:00:00"]
[null,"Thomas","09:00:00","15:40:00"]
[null,"Mark","08:38:00","16:50:00"]
[null,"Sandra","09:00:00","17:00:00"]

{"sheet":"Subtraction","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Subtraction to Calculate Time Range"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","08:30:00","16:30:00",{"$f":"D5-C5","v":"08:00:00"}]
[null,"Mary","08:02:00","16:48:00",{"$f":"D6-C6","v":"08:46:00"}]
[null,"Jones","09:04:00","17:00:00","07:56:00"]
[null,"Susan","08:45:00","16:50:00","08:05:00"]
[null,"James","08:23:00","17:06:00","08:43:00"]
[null,"Frank","09:20:00","17:50:00","08:30:00"]
[null,"Jennifer","08:10:00","17:00:00","08:50:00"]
[null,"Thomas","09:00:00","15:40:00","06:40:00"]
[null,"Mark","08:38:00","16:50:00","08:12:00"]
[null,"Sandra","09:00:00","17:00:00","08:00:00"]

{"sheet":"Hours, Minutes and Seconds","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Calculating Time Range in Hours, Minutes and Seconds"]
[]
[null,"Name","In Time","Out Time","Hours","Minutes","Seconds"]
[null,"Robin","08:30:00","16:30:00",{"$f":"(D5-C5)*24","v":8},{"$f":"(D5-C5)*24*60","v":480},{"$f":"(D5-C5)*24*60*60","v":28800}]
[null,"Mary","08:02:00","16:48:00",{"$f":"(D6-C6)*24","v":8.7666666666666693},526.00000000000011,31560.000000000007]
[null,"Jones","09:04:00","17:00:00",7.9333333333333345,476.00000000000006,28560.000000000004]
[null,"Susan","08:45:00","16:50:00",8.0833333333333321,484.99999999999994,29099.999999999996]
[null,"James","08:23:00","17:06:00",8.7166666666666686,523.00000000000011,31380.000000000007]
[null,"Frank","09:20:00","17:50:00",8.4999999999999982,509.99999999999989,30599.999999999993]
[null,"Jennifer","08:10:00","17:00:00",8.8333333333333357,530.00000000000011,31800.000000000007]
[null,"Thomas","09:00:00","15:40:00",6.666666666666667,400,24000]
[null,"Mark","08:38:00","16:50:00",8.1999999999999993,491.99999999999994,29519.999999999996]
[null,"Sandra","09:00:00","17:00:00",8,480,28800]

{"sheet":"TEXT Function","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying TEXT Function"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","08:30:00","16:30:00",{"$f":"TEXT(D5-C5,\"h:mm\")","v":"8:00"}]
[null,"Mary","08:02:00","16:48:00",{"$f":"TEXT(D6-C6,\"h:mm\")","v":"8:46"}]
[null,"Jones","09:04:00","17:00:00","7:56"]
[null,"Susan","08:45:00","16:50:00","8:05"]
[null,"James","08:23:00","17:06:00","8:43"]
[null,"Frank","09:20:00","17:50:00","8:30"]
[null,"Jennifer","08:10:00","17:00:00","8:50"]
[null,"Thomas","09:00:00","15:40:00","6:40"]
[null,"Mark","08:38:00","16:50:00","8:12"]
[null,"Sandra","09:00:00","17:00:00","8:00"]

{"sheet":"Time crosses Midnight","index":4,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF Function"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","08:30:00","16:30:00",{"$f":"IF(D5>C5,D5-C5,1-C5+D5)","v":"08:00:00"}]
[null,"Mary","08:02:00","16:48:00",{"$f":"IF(D6>C6,D6-C6,1-C6+D6)","v":"08:46:00"}]
[null,"Jones","09:04:00","17:00:00","07:56:00"]
[null,"Susan","08:45:00","16:50:00","08:05:00"]
[null,"James","08:23:00","17:06:00","08:43:00"]
[null,"Frank","09:20:00","05:50:00","20:30:00"]
[null,"Jennifer","08:10:00","17:00:00","08:50:00"]
[null,"Thomas","09:00:00","15:40:00","06:40:00"]
[null,"Mark","08:38:00","16:50:00","08:12:00"]
[null,"Sandra","09:00:00","08:00:00","23:00:00"]

{"sheet":"Time crosses Midnight (2)","index":5,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Implementing MOD Function"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","08:30:00","16:30:00",{"$f":"MOD(D5-C5,1)","v":"08:00:00"}]
[null,"Mary","08:02:00","16:48:00",{"$f":"MOD(D6-C6,1)","v":"08:46:00"}]
[null,"Jones","09:04:00","17:00:00","07:56:00"]
[null,"Susan","08:45:00","16:50:00","08:05:00"]
[null,"James","08:23:00","17:06:00","08:43:00"]
[null,"Frank","09:20:00","05:50:00","20:30:00"]
[null,"Jennifer","08:10:00","17:00:00","08:50:00"]
[null,"Thomas","09:00:00","15:40:00","06:40:00"]
[null,"Mark","08:38:00","16:50:00","08:12:00"]
[null,"Sandra","09:00:00","08:00:00","23:00:00"]

{"sheet":"Date and Time","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating with Date and Time"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","2022-06-01T08:30:00","2022-06-01T16:30:00",{"$f":"D5-C5","v":0.33333333333575865}]
[null,"Mary","2022-06-01T08:02:00","2022-06-01T16:48:00",{"$f":"D6-C6","v":0.36527777777519077}]
[null,"Jones","2022-06-01T09:04:00","2022-06-01T17:00:00",0.33055555555620231]
[null,"Susan","2022-06-01T08:45:00","2022-06-01T16:50:00",0.33680555555474712]
[null,"James","2022-06-01T08:23:00","2022-06-01T17:06:00",0.3631944444423425]
[null,"Frank","2022-06-01T09:20:00","2022-06-02T05:50:00",0.85416666666424135]
[null,"Jennifer","2022-06-01T08:10:00","2022-06-01T17:00:00",0.36805555555474712]
[null,"Thomas","2022-06-01T09:00:00","2022-06-01T15:40:00",0.27777777778101154]
[null,"Mark","2022-06-01T08:38:00","2022-06-01T16:50:00",0.34166666666715173]
[null,"Sandra","2022-06-01T09:00:00","2022-06-02T10:00:00",{"$f":"D14-C14","v":1.0416666666642413}]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Subtraction to Calculate Time Range"]
[]
[null,"Name","In Time","Out Time","Time Range"]
[null,"Robin","08:30:00","16:30:00",{"$f":"TimeRange(C5,D5)","v":"08:00:00"}]
[null,"Mary","08:02:00","16:48:00",{"$f":"TimeRange(C6,D6)","v":"08:46:00"}]
[null,"Jones","09:04:00","17:00:00",{"$f":"TimeRange(C7,D7)","v":"07:56:00"}]
[null,"Susan","08:45:00","16:50:00",{"$f":"TimeRange(C8,D8)","v":"08:05:00"}]
[null,"James","08:23:00","17:06:00",{"$f":"TimeRange(C9,D9)","v":"08:43:00"}]
[null,"Frank","09:20:00","17:50:00",{"$f":"TimeRange(C10,D10)","v":"08:30:00"}]
[null,"Jennifer","08:10:00","17:00:00",{"$f":"TimeRange(C11,D11)","v":"08:50:00"}]
[null,"Thomas","09:00:00","15:40:00",{"$f":"TimeRange(C12,D12)","v":"06:40:00"}]
[null,"Mark","08:38:00","16:50:00",{"$f":"TimeRange(C13,D13)","v":"08:12:00"}]
[null,"Sandra","09:00:00","17:00:00",{"$f":"TimeRange(C14,D14)","v":"08:00:00"}]

{"sheet":"DATEDIF","index":8,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employing DATEDIF Function"]
[]
[null,"Name","Date of Birth","Present Age"]
[null,"Robin","1997-05-01",{"$f":"DATEDIF(C5,TODAY(),\"y\")&\" yr\"","v":"25 yr"}]
[null,"Mary","1996-08-13","25 yr"]
[null,"Jones","1980-04-05","42 yr"]
[null,"Susan","1992-08-10","29 yr"]
[null,"James","1994-12-25","27 yr"]
[null,"Frank","1985-02-23","37 yr"]
[null,"Jennifer","1995-06-05","27 yr"]
[null,"Thomas","1987-05-04","35 yr"]
[null,"Mark","1998-09-06","23 yr"]
[null,"Sandra","1988-01-10","34 yr"]