handle edge case of end time = 12/1230pm, properly handle xx30 times
make sure to use existing department entry if it exists already to avoid duplication
initial views, gsub xx50 back to xx30 for times