We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
The solution to last week's Challenge can be found HERE!
It's that time of year again....the leaves are starting to change color, the smell of pumpkin spice is in the air, and the amount of daylight for @JoeM's post-work bike rides is getting smaller and smaller. Just how much daylight did we lose this month? Take this week's Challenge to find out! Using the Input data provided, calculate the amount of daylight for each day in September, as well as the day-to-day differences in daylight and the total difference from September 1 to September 30.
*If you'd like to use a dataset for your location, you can download data on sunrise/sunset times from this site: https://www.timeanddate.com/sun/usa/ for US-based users.
I wanted to calculate things quickly. I didn't constrain myself to the desired output format, but rather showed the difference between start and total time on a daily basis.
It is getting dark earlier, that's for sure. But there is a silver lining in that story. As you near the equator (get further from freezing weather), Summer days are shorter. In other words, there's another reason to want to be in Michigan. Of course, the opposite is true during the winter.
My solution! I modified the formatting of the end result a bit to show the am/pm for clarity on Sunrise/Sunset times and modified the Date column to include "Sep" in the date, rather than just the day of the month.