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

{"sheet":"HALL PASS HISTORY","index":0,"n_rows":11,"n_cols":6,"rows_kept":11}
[null,"HALL PASS HISTORY",{"$nulls":3},"Ms. Galvin's class, Room 34"]
[{"$nulls":5},{"$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":"2019-07-08"},"James","Bathroom","09:15:00","09:23:00"]
[null,{"$f":"TODAY()","v":"2019-07-08"},"John","Supply closet","10:11:00","10:16:00"]
[null,{"$f":"TODAY()+1","v":"2019-07-09"},"Shawn","Bathroom","13:33:00","13:36:00"]
[null,{"$f":"TODAY()+1","v":"2019-07-09"},"Phil","Bathroom","11:24:00","11:27:00"]
[null,{"$f":"TODAY()+2","v":"2019-07-10"},"John","Bathroom","11:40:00","11:44:00"]
[null,{"$f":"TODAY()+2","v":"2019-07-10"},"John","Bathroom"]
[null,{"$f":"TODAY()+3","v":"2019-07-11"},"James","Supply closet"]
[null,{"$f":"TODAY()+3","v":"2019-07-11"},"John","Bathroom"]