Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAsolution
Solution for the challenge hereafter!
2 Regex to get sunrise and sunset times: (\d\:\d\d).*
2 text to columns to split hours and minutes
formula to get Day duration
Multirow formula to get daylight diff:
if isnull([Row-1:Day duration (Minutes)]) then null()
else [Day duration (Minutes)]-[Row-1:Day duration (Minutes)]
endif
Summarize to get sum of daylight diff and union to get final table