Challenge #87: Losing Daylight

[edavilac]

Sharing my solution, thanks for the challenge!

Spoiler

[Emil_Kos]

Hi,

Sharing my solution.

Spoiler

[balajilolla]

Spoiler

Solution Attached

[izamryan]

RegEx is your friend, as is also DateTimeParse()

Spoiler

For this one I used two inline RegEx tools:
(\d:\d{2}.\w{2})
this slices out the stamp WITH the AM/PM.

I then used a Formula tool to convert the string into DateTime format so we can do calculations
DateTimeParse([Sunrise_time],"%I:%M %p")
the %p takes care of the AM/PM and
DateTimeDiff([Sunset_time],[Sunrise_time],"minutes")
takes care of the calculation of minutes, without necessitating complex logic to account for the 24-hour clock

Calculating the delta between the days seems a bit unintuitive, so I forced it with this inline IF:
iif([Row-1:Day Length (minutes)]-[Day Length (minutes)]>0,([Row-1:Day Length (minutes)]-[Day Length (minutes)])*-1,null())

I then used a Summary tool, Text Input tool and an Append Fields tool to mash up the last row to show the total difference over the whole month.

Overall it feels a little clumsy, especially the multi-row formula. But I approximated the solution (albeit I left mine with extraneous zero's or the seconds!)

[deepaksaldanha]

Thank you for this stimulation exercise. Attached herein solution using the summarize tool.

[deviseetharaman]

Spoiler

[htrivedi123]

My solution attached. In comparison to others I have similar steps except at the end I have used ABSOLUTE values vs -ve variance. 

this was fun!!

[ALexAn]

Spoiler

 

[Allemar]

my solution