Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #68: Elapsed Classroom Times

Highlighted
8 - Asteroid

Here is my solution.

Spoiler
WeeklyChallenge_Ryohei_68.JPG
Highlighted
7 - Meteor

Soln

Highlighted
7 - Meteor
Spoiler
cmv_0-1592432197793.png

 

Highlighted
8 - Asteroid

Date tool seems to worry about the colons. Just warnings though

Tberney_0-1592432695098.png

 

Highlighted
8 - Asteroid

Solution attached

Highlighted
7 - Meteor

Done, learning something new for every challenge.

Dumb enough to use right(left(string,8),5) to take out the HH:MM.

It works but the date-time format formula is much better!

Highlighted
7 - Meteor

Here is my solution

Highlighted
8 - Asteroid
Spoiler
JohanRanschaert_0-1593783065300.png

 

In attach my solution

Highlighted
8 - Asteroid

.

Highlighted
8 - Asteroid

My solution

Spoiler
Img 68.PNG