I need to find out how many hours about 25 classrooms are being used. Each classroom has multiple classes each week. The start and end times are in military time but without the colon ie. 0900 to 1300; not 09:00 to 13:00. When I try to format the cells to time, all the data disappears. Any ideas??