Challenge #87: Losing Daylight
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SaâdEnnassiri
8 - Asteroid
07-27-2020
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
pawanmalik
8 - Asteroid
07-27-2020
04:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JoePC
9 - Comet
07-28-2020
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
josh_ebg
6 - Meteoroid
07-28-2020
05:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nmao
6 - Meteoroid
07-29-2020
08:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nmao
6 - Meteoroid
07-29-2020
09:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
troyeb4
8 - Asteroid
07-29-2020
01:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
rayJ
8 - Asteroid
07-29-2020
06:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
8 - Asteroid
07-31-2020
07:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kevin025
8 - Asteroid
07-31-2020
07:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.