Challenge #87: Losing Daylight

[PhilipMannering]

Solution attached.

Spoiler

[data_rachel]

This took me a relatively long time! After struggling with the datetime tools, here is my solution.

Spoiler

[ggruccio]

Lots of parsing, good exercise!

[samN]

another regex challenge. I wish there was a way to construct a date time object using a formula.

[jasperlch]

Solution attached.

[JosephSerpis]

Challenge Completed

[kat]

Here is my solution. I did it without changing the sunset and sunrise to datetime format.

Data is from Jersey (UK).

Spoiler

[TeePee]

Spoiler

I really enjoyed this challenge.  It helped me get to grips with stripping out different parts of strings and concatenating.  I'm also loving padleft :) 

I wanted to use the DateTimeDiff function so got it to work by inserting a random Date for both the dt arguments.  It would be good to know if this was strictly necessary. Thanks!

[SGolnik]

Another fun one!

[kcgreen]

I had difficulty with this one.   I ended up with the right answer but think I made it harder than I needed to.

Spoiler