{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Format Cells Window","TEXT Function","TIME and Other Functions","Excel VBA","Time Units","Hours to Time","Minutes to Time","Seconds to Time","Time to H M S"],"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":"Format Cells Window","index":0,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of Format Cells Window",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number","Time",null,null,null,null,null,null,null,null,null,"Number","Time"]
[null,2.8,{"$f":"B5/24","v":"02:48:00"},null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,{"$f":"B6/24","v":"03:06:00"},null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"03:40:12",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"07:18:00",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,"08:10:12",null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"TEXT Function","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number","Time",null,null,null,null,null,null,null,null,null,"Number","Time"]
[null,2.8,{"$f":"TEXT(B5/24,\"hh:mm:ss AM/PM\")","v":"02:48:00 AM"},null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,{"$f":"TEXT(B6/24,\"hh:mm:ss AM/PM\")","v":"03:06:00 AM"},null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"03:40:12 AM",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"07:18:00 AM",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,"08:10:12 AM",null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"TIME and Other Functions","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of TIME, LEFT, RIGHT and LEN Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number","Time",null,null,null,null,null,null,null,null,null,"Number","Time"]
[null,2.8,{"$f":"TIME(LEFT(B5,LEN(B5)-2),RIGHT(B5,2),)","v":"02:00:00"},null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,{"$f":"TIME(LEFT(B6,LEN(B6)-2),RIGHT(B6,2),)","v":"03:00:00"},null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"04:07:00",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"07:00:00",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,{"$f":"TIME(LEFT(B9,LEN(B9)-2),RIGHT(B9,2),)","v":"08:17:00"},null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"Excel VBA","index":3,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number","Time",null,null,null,null,null,null,null,null,null,"Number","Time"]
[null,2.8,"02:48:00",null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,"03:06:00",null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"03:40:12",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"07:18:00",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,"08:10:12",null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"Time Units","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Convert Numbers to Time Units",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number","Time",null,null,null,null,null,null,null,null,null,"Number","Time"]
[null,2.8,{"$f":"TEXT(B5/24,\"[h] \"\"hours,\"\" m \"\"minutes, \"\" s \"\"seconds\"\"\")","v":"2 hours, 48 minutes,  0 seconds"},null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,{"$f":"TEXT(B6/24,\"[h] \"\"hours,\"\" m \"\"minutes, \"\" s \"\"seconds\"\"\")","v":"3 hours, 6 minutes,  0 seconds"},null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"3 hours, 40 minutes,  12 seconds",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"7 hours, 18 minutes,  0 seconds",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,"8 hours, 10 minutes,  12 seconds",null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"Hours to Time","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Convert Hours to Time",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number (Hours)","Time",null,null,null,null,null,null,null,null,null,"Number (Hours)","Time"]
[null,2.8,{"$f":"B5/24","v":"02:48:00"},null,null,null,null,null,null,null,null,null,2.8]
[null,3.1,{"$f":"B6/24","v":"03:06:00"},null,null,null,null,null,null,null,null,null,3.1]
[null,3.67,"03:40:12",null,null,null,null,null,null,null,null,null,3.67]
[null,7.3,"07:18:00",null,null,null,null,null,null,null,null,null,7.3]
[null,8.17,"08:10:12",null,null,null,null,null,null,null,null,null,8.17]

{"sheet":"Minutes to Time","index":6,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Convert Minutes to Time",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number (Minutes)","Time",null,null,null,null,null,null,null,null,null,"Number (Minutes)","Time"]
[null,123.8,{"$f":"B5/1440","v":"02:03:48"},null,null,null,null,null,null,null,null,null,123.8]
[null,334.1,{"$f":"B6/1440","v":"05:34:06"},null,null,null,null,null,null,null,null,null,334.1]
[null,321.67,"05:21:40.200",null,null,null,null,null,null,null,null,null,321.67]
[null,421.33,"07:01:19.800",null,null,null,null,null,null,null,null,null,421.33]
[null,814.17,"13:34:10.200",null,null,null,null,null,null,null,null,null,814.17]

{"sheet":"Seconds to Time","index":7,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Convert Seconds to Time",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Number (Seconds)","Time",null,null,null,null,null,null,null,null,null,"Number (Seconds)","Time"]
[null,12351.8,{"$f":"B5/86400","v":"03:25:51.800"},null,null,null,null,null,null,null,null,null,12351.8]
[null,33493.1,{"$f":"B6/86400","v":"09:18:13.100"},null,null,null,null,null,null,null,null,null,33493.1]
[null,32174.67,"08:56:14.670",null,null,null,null,null,null,null,null,null,32174.67]
[null,42132.33,"11:42:12.330",null,null,null,null,null,null,null,null,null,42132.33]
[null,81421.17,"22:37:01.170",null,null,null,null,null,null,null,null,null,81421.17]

{"sheet":"Time to H M S","index":8,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Convert Time to Hours, Minutes and Seconds",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Time","Hours","Minutes","Seconds",null,null,null,null,null,null,null,"Time","Hours","Minutes","Seconds"]
[null,"03:25:51.800",{"$f":"B5*24","v":3.4310555555555551},{"$f":"B5*1440","v":205.86333333333332},{"$f":"B5*86400","v":12351.799999999997},null,null,null,null,null,null,null,"03:25:51.800",null,{"$f":"B5*1440","v":205.86333333333332},{"$f":"B5*86400","v":12351.799999999997}]
[null,"09:18:13.100",{"$f":"B6*24","v":9.303638888888889},{"$f":"B6*1440","v":558.21833333333336},{"$f":"B6*86400","v":33493.1},null,null,null,null,null,null,null,"09:18:13.100",null,{"$f":"B6*1440","v":558.21833333333336},{"$f":"B6*86400","v":33493.1}]
[null,"08:56:14.670",8.9374083333333338,536.24450000000002,32174.67,null,null,null,null,null,null,null,"08:56:14.670",null,536.24450000000002,32174.67]
[null,"11:42:12.330",11.703424999999999,702.20550000000003,42132.33,null,null,null,null,null,null,null,"11:42:12.330",null,702.20550000000003,42132.33]
[null,"22:37:01.170",22.616991666666667,1357.0194999999999,81421.17,null,null,null,null,null,null,null,"22:37:01.170",null,{"$f":"B9*1440","v":1357.0194999999999},{"$f":"B9*86400","v":81421.17}]