This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackLast week's solution has been posted HERE.
A university analyst has been asked to help with course and classroom resource planning. The university sends course times in military time format. The university analyst wants the fields Military Begin Time and Military End Time to display in standard, 12-hour increments. So, if a course ends at 16:30, he would like it to show as 4:30. He also wants to know what the elapsed time is between the two fields mentioned above. How long is each course? Minutes will be the time unit measured.
@MarqueeCrew, part of the challenge is to convert military time to display as standard time :)
My one-tool (plus a Select) solution!
PS. I took the liberty of adding some extra "data validation" to my answers, since there were a few unusual entries... For example: University students have a hard enough time keeping track of class times without worrying whether the start time is listed as after the end time...
Here's the route I went down.
I feel I used too many tools to solve this... I also thought to use a macro I built about duration, but I felt like cheating, so I made it from scratch :)
Good one! :)
Very very similar solution to @BenMoss