Challenge #68: Elapsed Classroom Times

[RobertoEstrada]

Here is my solution, it is a little bit different than the proposed one but I got the same results.

[nivi_s]

Challenge #68 solved!

[anishanayak]

Solution attached

[Inactive User]

[Deevi]

Great challenge!

Spoiler

[CaraI]

I thought about doing it all in just a formula tool, but why waste all of the dev effort put into the Date Time Parse?

Spoiler

[Laszlo_D]

[Bluemoon]

Lots of if!

Spoiler

[SueDonim]

I suspect my answer is a bit too brute force (due to my not yet knowing all of the datetime functions, but I got there.  Thanks to Marquee Crew's Expect Equal tool, I found some problems along the way.  And in fact, there are some negative elapsed times in the solution set (ahem!)

What I learned:

- Don't trust the first few records as proving the accuracy of your result

- Expect Equal is pretty awesome

- There should be universal time standards (enforceable by a long sentence at hard labour) so this sort of problem doesn't arise ever again

Spoiler

Process:
- Add leading 0 to time string if needed
- Convert start and end times to datetime format
- Calculate difference between start and end time
- Remove additional 12 hours for afternoon/evening times
- Add leading 0 to time string if needed

[SueDonim]

Your solution is so much simpler than mine - good lessons - thanks