Challenge #68: Elapsed Classroom Times

[robertamcarlos]

Spoiler

Spoiler

Spoiler

[kelly_gilbert]

@justindavis I found it super helpful to bookmark this link: Date/Time Functions...  Click on Specifiers to see the full list of different specifiers for use in the DateTimeFormat or DateTimeParse functions. I refer to this list all of the time!

You might also find the examples in this post helpful in addition to the Weekly Challenges. You're right - the hands-on practice is hugely helpful!

[justindavis]

Thanks @kelly_gilbert those are sure to be super helpful! I had found the first one with the list of functions and specifiers, but not the second post, which looks promising. Years of easy conversions in SQL makes it a more difficult transition but I'm sure I can nail it down.

[Greg_Murray]

Solution attached

[Rahma]

workflow attached! 

[mcultrera]

Clunky and uncomfortable but I got the same result...

[Etienne]

Good practice for date time formatting

[RichardLengua]

Went a little crazy with the data cleaning and formatting of the datetime columns.

Spoiler

[Vidya26]

My Solution!