I spent hours using Date Time tool + Formula tool to get the right formatting, and it simply would not work. Gave up and just made a bunch of formulas using DateTimeParse and DateTimeFormat. It looks cleaner because there are less tools in the workflow, but it probably takes longer because the formula tool is doing a lot of work that the DateTime tool is supposed to do more efficiently.
Biggest issue was when I got the Date Time tool to output standard time, it kept the seconds bit (e.g. 04:07:00) and I could not for the life of me change it without destroying the Elapsed Time column. Either one worked, or the other didn't.
Lastly, this university likely needs to clean their data. Some classes took negative time (record 476 goes from 1600 to 1000), some classes take FOREVER (record 262 goes from 700 to 2300), and there are many nulls. If the data is correct, I feel sorry for anyone who is wasting their Fridays with a 16 hour course, but it might be fun figuring out time travel with a course that lasts -6 hours (or maybe it's until 10 the next day?).
