{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Worksheet","index":0,"n_rows":12,"n_cols":20,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,18],[1,0,1,1],[3,0,3,1],[1,3,1,5],[1,9,1,11],[1,15,1,17]]}
[null,null,{"$f":"IF(B5=1,\"Change these 12 hour (am/pm) times to 24 hour times\",IF(B5=2,\"Change these 24 hour times to 12 hour (am/pm) time\",\"Change these times from 24 hour time to 12 hour (am/pm) time and vice-versa\"))","v":"Change these times from 24 hour time to 12 hour (am/pm) time and vice-versa"}]
["Variables",null,null,"12 hour (am/pm) time",null,null,"24 hour time",null,null,"12 hour (am/pm) time",null,null,"24 hour time",null,null,"12 hour (am/pm) time",null,null,"24 hour time"]
["SHOW ANSWERS",false,1,4,46,"am","04 46",1,11,8,59,"am","08 59",2,21,11,44,"pm","23 44",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
["Types of questions",null,2,6,10,"pm","18 10",2,12,9,14,"pm","21 14",2,22,10,27,"am","10 27",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
["Convert 12 hour to 24 hour",3,3,7,25,"pm","19 25",2,13,11,22,"pm","23 22",1,23,2,50,"am","02 50",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
["Convert 24 hour to 12 hour",null,4,12,37,"am","00 37",2,14,6,32,"pm","18 32",2,24,5,22,"pm","17 22",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
["A mixture",null,5,7,22,"pm","19 22",2,15,10,33,"pm","22 33",2,25,5,13,"am","05 13",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[null,null,6,9,36,"pm","21 36",2,16,7,57,"pm","19 57",2,26,4,1,"am","04 01",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[null,null,7,5,3,"pm","17 03",1,17,3,16,"am","03 16",1,27,2,19,"pm","14 19",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[null,null,8,6,12,"pm","18 12",2,18,1,53,"pm","13 53",1,28,3,55,"pm","15 55",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[null,null,9,2,46,"am","02 46",1,19,7,7,"am","07 07",1,29,7,55,"pm","19 55",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[null,null,10,4,23,"pm","16 23",2,20,3,51,"am","03 51",2,30,11,12,"pm","23 12",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,7,0,9],[0,13,0,15]]}
[null,"12 hour time",null,null,"24 hour time",null,null,"12 hour time",null,null,"24 hour time",null,null,"12 hour time",null,null,"24 hour time"]
[1,{"$f":"RANDBETWEEN(1,12)","v":6},{"$f":"RANDBETWEEN(0,59)","v":45},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"pm"},{"$f":"CONCATENATE(IF(B2=12,IF(D2=\"pm\",12,\"00\"),IF(D2=\"am\",TEXT(B2,\"00\"),B2+12)),\" \",TEXT(C2,\"00\"))","v":"18 45"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},11,{"$f":"RANDBETWEEN(1,12)","v":4},{"$f":"RANDBETWEEN(0,59)","v":18},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"am"},{"$f":"CONCATENATE(IF(H2=12,IF(J2=\"pm\",12,\"00\"),IF(J2=\"am\",TEXT(H2,\"00\"),H2+12)),\" \",TEXT(I2,\"00\"))","v":"04 18"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},21,{"$f":"RANDBETWEEN(1,12)","v":2},{"$f":"RANDBETWEEN(0,59)","v":45},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"pm"},{"$f":"CONCATENATE(IF(N2=12,IF(P2=\"pm\",12,\"00\"),IF(P2=\"am\",TEXT(N2,\"00\"),N2+12)),\" \",TEXT(O2,\"00\"))","v":"14 45"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[{"$f":"A2+1","v":2},{"$f":"RANDBETWEEN(1,12)","v":10},{"$f":"RANDBETWEEN(0,59)","v":15},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"am"},{"$f":"CONCATENATE(IF(B3=12,IF(D3=\"pm\",12,\"00\"),IF(D3=\"am\",TEXT(B3,\"00\"),B3+12)),\" \",TEXT(C3,\"00\"))","v":"10 15"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"G2+1","v":12},{"$f":"RANDBETWEEN(1,12)","v":2},{"$f":"RANDBETWEEN(0,59)","v":49},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"pm"},{"$f":"CONCATENATE(IF(H3=12,IF(J3=\"pm\",12,\"00\"),IF(J3=\"am\",TEXT(H3,\"00\"),H3+12)),\" \",TEXT(I3,\"00\"))","v":"14 49"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"M2+1","v":22},{"$f":"RANDBETWEEN(1,12)","v":9},{"$f":"RANDBETWEEN(0,59)","v":42},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"am\",\"pm\")","v":"pm"},{"$f":"CONCATENATE(IF(N3=12,IF(P3=\"pm\",12,\"00\"),IF(P3=\"am\",TEXT(N3,\"00\"),N3+12)),\" \",TEXT(O3,\"00\"))","v":"21 42"},{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[{"$f":"A3+1","v":3},2,6,"am","02 06",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"G3+1","v":13},11,35,"pm","23 35",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"M3+1","v":23},8,57,"pm","20 57",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[{"$f":"A4+1","v":4},9,57,"am","09 57",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"G4+1","v":14},1,18,"pm","13 18",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},{"$f":"M4+1","v":24},2,22,"am","02 22",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[5,11,57,"am","11 57",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},15,5,59,"pm","17 59",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},25,5,46,"pm","17 46",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[6,12,56,"am","00 56",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},16,11,48,"pm","23 48",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},26,8,31,"pm","20 31",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[7,9,50,"am","09 50",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},17,1,33,"pm","13 33",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},27,1,29,"pm","13 29",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2}]
[8,5,57,"am","05 57",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},18,9,15,"pm","21 15",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},28,5,12,"pm","17 12",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[9,11,36,"am","11 36",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},19,7,54,"pm","19 54",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":2},29,12,46,"am","00 46",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]
[10,12,2,"am","00 02",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},20,6,48,"pm","18 48",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1},30,5,29,"pm","17 29",{"$f":"IF(Worksheet!$B$5=1,1,IF(Worksheet!$B$5=2,2,RANDBETWEEN(1,2)))","v":1}]