Challenge #87: Losing Daylight

[SaâdEnnassiri]

That was cool. Thx

[pawanmalik]

My solution for this callenge.

[JoePC]

Solution Attached

[josh_ebg]

My Solution 🙂

[nmao]

Challenge 87

[nmao]

Corrected Challenge 87 

[troyeb4]

Definitely learning to manipulate time in several ways. Good Challenge

Spoiler

[rayJ]

Spoiler

Very nice practice. Had to use union to join the September row. Macro seems able to do the same but I am not there yet. 

[carmenrapariz]

Spoiler

[kevin025]

Here is my solution with Formula explained.

Spoiler

We use Formula tool to extract Hours and Minutes
For Sunrise and Sunset, hours and minutes positions are the same so we use Left([Sunrise),4)

• 4 means total length it will grab is 4
• To convert to 24 hours we simply do:
• ToString(ToNumber(Left([Sunset], 1))+12)+Right([Sunset], 3)
• To break this down, we use Left([Sunset], 1)) to grab the first digit which is "7"
• We then convert it to number then add 12 by using ToNumber() function which will give us "19"
• We then convert it back to string and add the rest of the string back by using ToString and Right([Sunset],3)
• 3 means we will grab 3 letters including ":"

Voila! You have yourself a 24 hours time just like that.