Attached are my solutions to my first Weekly Challenge. I created two solutions; the first uses the existing data set and the second uses sunrise/sunset data from three cities around the world, including one that is the southern hemisphere. As such, the days in Johannesburg are growing longer as ours are growing shorter. This is my first challenge and as such, I probably over-complicated the solutions. However, I had a fun time creating clean Data and DateTime fields.
Took a slightly different approach, and transposed the times into one column to parse and prep with one formula tool.