Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

スポイラ

troyeb4_0-1596054243204.png

 

rayJ
アステロイド
スポイラ
rayJ_0-1596070740250.png

 

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
アステロイド
スポイラ
Challenge 87.PNG
kevin025
アステロイド

Here is my solution with Formula explained.

 

スポイラ

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.

 

 

 

challenge#87.png