{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Time_Intervals"],"not_rendered":{"charts":0,"images":4,"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":"Time_Intervals","index":0,"n_rows":55,"n_cols":58,"rows_kept":55,"cut":false,"hidden":false,"merged":[[47,23,47,26],[36,25,36,28],[51,40,51,41],[52,38,52,39],[52,40,52,41],[46,23,46,26],[38,38,38,39],[44,23,44,26],[45,23,45,26],[43,23,43,26],[54,38,54,39],[54,40,54,41],[51,38,51,39],[49,38,49,39],[49,40,49,41],[50,38,50,39],[50,40,50,41],[53,38,53,39],[53,40,53,41],[43,8,43,14],[47,15,47,18],[47,8,47,14],[46,19,46,22],[46,8,46,14],[44,19,44,22],[44,15,44,18],[43,15,43,18],[43,19,43,22],[44,8,44,14],[45,8,45,14],[45,15,45,18],[46,15,46,18],[47,19,47,22],[45,19,45,22],[38,34,38,35],[11,37,11,38],[11,39,11,40],[15,38,15,42],[24,38,24,42],[25,38,25,41],[27,34,27,35],[27,38,27,39],[31,25,31,28],[32,25,32,28],[33,25,33,28],[34,25,34,28],[35,25,35,28],[1,1,5,43],[9,19,9,22],[9,33,9,36],[9,26,9,28],[12,8,12,9],[11,8,11,9],[12,10,12,11],[12,39,12,40],[11,23,11,24],[11,25,11,26],[9,11,9,15],[9,40,9,43],[9,3,9,7],[11,10,11,11],[21,37,21,38],[22,37,22,38],[22,39,22,40],[16,38,16,41],[19,34,19,35],[19,38,19,39],[12,23,12,24],[12,25,12,26],[12,37,12,38],[18,34,18,35],[18,38,18,39]]}
[]
[null,"N4 Lifeskills - Time                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com          "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L10-D10","v":"17:27:00"},{"$f":"HOUR(AZ7)","v":17},null,{"$f":"MINUTE(AZ7)","v":27}]
[null,{"$f":"\"Q1.  Calculate the time difference between the times.\"","v":"Q1.  Calculate the time difference between the times."}]
[]
[null,"(a)",null,{"$f":"TIME(RAND()*(11-2)+2,RAND()*(59-1)+1,)","v":"02:14:00"},null,null,null,null,null,"to",null,{"$f":"TIME(RAND()*(23-13)+13,RAND()*(59-1)+1,)","v":"19:41:00"},null,null,null,null,null,"(b)",null,{"$f":"TIME(RAND()*(11-2)+2,RAND()*(58-32)+32,)","v":"06:53:00"},null,null,null,null,"to",null,{"$f":"TIME(RAND()*(23-13)+13,RAND()*(29-1)+1,)","v":"14:10:00"},null,null,null,null,"(c)",null,{"$f":"TIME(RAND()*(9-2)+2,RAND()*(59-31)+31,)","v":"06:58:00"},null,null,null,null,"to",null,{"$f":"TIME(RAND()*(23-13)+13,RAND()*(29-1)+1,)","v":"18:16:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"AA10-T10","v":"07:17:00"},{"$f":"HOUR(AZ10)","v":7},null,{"$f":"MINUTE(AZ10)","v":17}]
[]
[null,null,null,null,null,null,null,null,"hrs",null,"mins",null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins",null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO10-AH10","v":"11:18:00"},{"$f":"HOUR(AZ13)","v":11},null,{"$f":"MINUTE(AZ13)","v":18}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(eg. 3.45pm)"]
[null,{"$f":"\"Q2.  Paul works night shift and sleeps during the day. He set his alarm to go off at \"&AU20&\":\"&AV20&\". Write in 12-hour format.\"","v":"Q2.  Paul works night shift and sleeps during the day. He set his alarm to go off at 16:40. Write in 12-hour format."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pm",null,null,null,null,null,null,null,null,{"$f":"AU20-12+AV20/100","v":4.4000000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,null,null,"mins"]
[null,null,null,{"$f":"\"He goes to bed at 0\"&AU21&\":\"&AV21&\".  How long before his alarm will go off.\"","v":"He goes to bed at 07:25.  How long before his alarm will go off."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((RAND()*(17-15)+15),0)","v":16},{"$f":"ROUND((RAND()*(5-1)+1),0)*10","v":40},null,null,null,{"$f":"AU20-AU21-1+BB21","v":9},{"$f":"BD21","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((RAND()*(9-7)+7),0)","v":7},{"$f":"ROUND((RAND()*(11-2)+2),0)*5","v":25},null,null,null,{"$f":"60-AV21+AV20","v":75},null,{"$f":"TRUNC(AZ21/60)","v":1},null,{"$f":"MOD(AZ21,60)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(25-15)+15,0)*5","v":110},{"$f":"TIME(0,AY22,0)","v":"01:50:00"}]
[null,{"$f":"\"Q3.  A film lasts \"&AY22&\" mins. If the film starts at \"&TEXT(AZ23,\"hh:mm\")&\".  When does the film finish.\"","v":"Q3.  A film lasts 110 mins. If the film starts at 16:30.  When does the film finish."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(24 hr format)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(RAND()*(21-13)+13,ROUND(RAND()*(11-0)+0,0)*5,0)","v":"16:30:00"},{"$f":"AY23","v":"16:30:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ22+AZ23","v":"18:20:00"},{"$f":"HOUR(AZ24)","v":18},{"$f":"MINUTE(AZ24)","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(eg. 3.45pm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BB24+BB23","v":20},{"$f":"BC24+BC23","v":0},null,{"$f":"TRUNC(BC25/60)","v":0},{"$f":"MOD(BC25,60)","v":0}]
[null,{"$f":"\"Q4.  Sean is running a marthon race in Glasgow. The race begins at \"&AU27&\":\"&AV27&\" . Write in 12-hour format.\"","v":"Q4.  Sean is running a marthon race in Glasgow. The race begins at 16:25 . Write in 12-hour format."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pm",null,null,null,null,null,null,null,null,{"$f":"AU27-12+AV27/100","v":4.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((RAND()*(17-15)+15),0)","v":16},{"$f":"ROUND((RAND()*(11-2)+2),0)*5","v":25}]
[null,null,null,{"$f":"\"Sean finishes the race at \"&AU28&\":\"&AV28&\" . How long did she take to finish the race.\"","v":"Sean finishes the race at 20:50 . How long did she take to finish the race."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,null,null,"mins",null,null,null,null,null,{"$f":"ROUND((RAND()*(20-19)+19),0)","v":20},{"$f":"ROUND((RAND()*(11-2)+2),0)*5","v":50},null,null,null,{"$f":"AU28-AU27-1+BB29","v":4},{"$f":"BD29","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"60-AV27+AV28","v":85},null,{"$f":"TRUNC(AZ29/60)","v":1},null,{"$f":"MOD(AZ29,60)","v":25}]
[]
[null,{"$f":"\"Q5.  Part of a TV programme listing is shown opposite. \"","v":"Q5.  Part of a TV programme listing is shown opposite. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(RAND()*(16-15)+15,ROUND(RAND()*(11-0)+0,0)*5,0)","v":"15:25:00"},null,null,null,"Cloud sports"]
[null,null,null,"How long does the film last altogether?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(RAND()*(18-16)+16,ROUND(RAND()*(11-0)+0,0)*5,0)","v":"16:40:00"},null,null,null,"Travel Show"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(RAND()*(20-19)+19,ROUND(RAND()*(11-0)+0,0)*5,0)","v":"19:50:00"},null,null,null,"Film : The Warriors (Part 2 after the News)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(1,ROUND(RAND()*(6-0)+0,0)*5,0)","v":"01:10:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z34+AZ34","v":"21:00:00"},null,null,null,"News",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(0,ROUND(RAND()*(6-0)+0,0)*5,0)","v":"00:20:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z35+AZ35","v":"21:20:00"},null,null,null,"Film : The Warriors Part 2 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z35-Z34","v":"01:10:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(RAND()*(23-22)+22,RAND()*(29-2)+2,)","v":"22:22:00"},null,null,null,"Clubscene",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z37-Z36","v":"01:02:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ36+AZ37","v":"02:12:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,null,null,"mins",null,null,null,null,null,null,null,null,null,null,{"$f":"HOUR(AZ38)","v":2},{"$f":"MINUTE(AZ38)","v":12}]
[]
[]
[null,"Q6.  Part of a bus timetable is given below."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus 1",null,null,null,"Bus 2",null,null,null,"Bus 3"]
[null,null,null,null,null,null,null,null,"Glasgow",null,null,null,null,null,null,{"$f":"TIME(RAND()*(14-13)+13,RAND()*(55-33)+33,)","v":"13:40:00"},null,null,null,{"$f":"TIME(RAND()*(18-17)+17,RAND()*(25-1)+1,)","v":"17:19:00"},null,null,null,{"$f":"TIME(RAND()*(2-1)+1,RAND()*(59-34)+34,)","v":"01:43:00"}]
[null,null,null,null,null,null,null,null,"Perth",null,null,null,null,null,null,{"$f":"TIME(RAND()*(16-15)+15,RAND()*(55-35)+35,)","v":"15:35:00"},null,null,null,{"$f":"TIME(RAND()*(20-19)+19,RAND()*(55-35)+35,)","v":"19:52:00"},null,null,null,{"$f":"TIME(RAND()*(4-3)+3,RAND()*(55-35)+35,)","v":"03:46:00"}]
[null,null,null,null,null,null,null,null,"Dundee",null,null,null,null,null,null,{"$f":"TIME(RAND()*(18-17)+17,RAND()*(28-3)+3,)","v":"17:26:00"},null,null,null,{"$f":"TIME(RAND()*(22-21)+21,RAND()*(29-1)+1,)","v":"21:13:00"},null,null,null,{"$f":"TIME(RAND()*(6-5)+5,RAND()*(29-1)+1,)","v":"05:24:00"}]
[null,null,null,null,null,null,null,null,"Aberdeen",null,null,null,null,null,null,{"$f":"TIME(RAND()*(20-19)+19,RAND()*(59-32)+32,)","v":"19:54:00"},null,null,null,{"$f":"TIME(RAND()*(23-23)+23,RAND()*(29-2)+2,)","v":"23:26:00"},null,null,null,{"$f":"TIME(RAND()*(7-6)+6,RAND()*(29-9)+9,)","v":"06:26:00"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins"]
[null,null,"(a)",null,"How long does bus 1 take to travel from Glasgow to Dundee.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P47-P45","v":"03:46:00"},{"$f":"HOUR(AZ51)","v":3},null,null,{"$f":"MINUTE(AZ51)","v":46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins"]
[null,null,"(b)",null,"How long does bus 2 take to travel from Perth to Aberdeen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T48-T46","v":"03:34:00"},{"$f":"HOUR(AZ53)","v":3},null,null,{"$f":"MINUTE(AZ53)","v":34}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hrs",null,"mins"]
[null,null,"(c)",null,"How long does bus 3 take to travel from Glasgow to Aberdeen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X48-X45","v":"04:43:00"},{"$f":"HOUR(AZ55)","v":4},null,null,{"$f":"MINUTE(AZ55)","v":43}]