{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["TOILET PASS HISTORY"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"TOILET PASS HISTORY","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,2],[0,3,0,5],[1,1,1,5]]}
[null,"TOILET PASS HISTORY",null,"Ms. Smith’s class, Room 34"]
[null,{"$f":"IFERROR(\"Average time: \"&TEXT((SUBTOTAL(109,Pass[RETURN TIME])-SUBTOTAL(109,Pass[DEPARTURE TIME]))/SUBTOTAL(102,Pass[DEPARTURE TIME]),\"[h]:mm\"),\"Enter Return Time to see Average time\")","v":"Average time: 0:04"}]
[null,"DATE","STUDENT","DESTINATION","DEPARTURE TIME","RETURN TIME"]
[null,{"$f":"TODAY()","v":"2018-05-22"},"James","Toilet","09:15:00","09:23:00"]
[null,{"$f":"TODAY()","v":"2018-05-22"},"John","Store cupboard","10:11:00","10:16:00"]
[null,{"$f":"TODAY()+1","v":"2018-05-23"},"Shaun","Toilet","13:33:00","13:36:00"]
[null,{"$f":"TODAY()+1","v":"2018-05-23"},"Phil","Toilet","11:24:00","11:27:00"]
[null,{"$f":"TODAY()+2","v":"2018-05-24"},"John","Toilet","11:40:00","11:44:00"]
[null,{"$f":"TODAY()+2","v":"2018-05-24"},"John","Toilet"]
[null,{"$f":"TODAY()+3","v":"2018-05-25"},"James","Store cupboard"]
[null,{"$f":"TODAY()+3","v":"2018-05-25"},"John","Toilet"]