Challenge #68: Elapsed Classroom Times

[jacob]

Spoiler

I've also come up with a one formula tool solution. I really like the colorful support the new formula tool offers.

[LordNeilLord]

Same solution as most :)

Spoiler

[A_Twa]

File under "More than one way to skin a cat"

Spoiler

I fully expected my DateTimeFormat + DateTimeParse + PadLeft formulas to be the 'official' solution - and then I looked at the formulas used in the official answer. ;)

[MsBindy]

I have some confusion between DateTimeParse and DateTimeFormat,  but with some trial and error I did manage to get a solution.

[Elena_Caric]

Learning so much today! :)

[jamielaird]

Here's my solution.  I transposed both time fields into one column to save having to run the conversions twice, but then had to cross-tab twice at the end, so I'm not sure if it actually saved any steps.

UPDATE: Looking at everyone else's solutions there are MUCH easier ways to do this, but I guess that's why this is a learning exercise. :-)

Spoiler

[nick_ceneviva]

Solution attached.

[patrick_digan]

Spoiler

[data_rachel]

Spoiler

Looks like I could have probably done it with fewer formula tools? Found this one a bit fiddly.

[samjohnson]

This challenge may seem simple, but there are some tricky points, including where a class begins in the morning and ends in the afternoon, which requires the absolute value between two times.

My solutions rarely use as few tools as possible; I've found that the more tightly wound the code within a tool is the harder it is to transition the project to someone else who may or may not have the same expertise (be it more or less). I like trying to use the base tools to solve the problem, and fully admit that I don't have a complete grasp of every tool in every category, but I'm trying!

Spoiler