Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution attached.
I have questions and disgruntlements with this one. What schedule doesn't use the 24 hour clock for clarity? Why convert it to a 12 hour clock is the purpose is analysis? If we are doing this, why not convert to an actual date-time so that datetime math can be used? Why does the solution not want us to specify AM versus PM? How are there classes on the schedule that end before they start - are they literally 23 hour classes? Why eliminated "TBD" classes and Null times in this case? Shouldn't those still be included for schedule clarity?
Instead of one complicated formula function that doesn't convert to datetime, just "gives the answer" I did break our the strings and used RegEx to define the time "words" of the times in string form. If someone could give a good walkthrough on how to do the datetime conversion from string cleanly I'd actually like to know that
I had the same thought and problem, when working with a number the math was easy - if over 1200 subtract 1200, done. But you can't add leading 0's to Numbers, just strings. I tore my hair out for a bit trying to get that I would want my expectations to be to match what they were willing to work with.
After all, why not just use 24 hour time? It makes so much more sense.