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 #34: Date-Time Formatting

EamonnW
6 - Meteoroid
Spoiler
EamonnW_0-1669114294044.png

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1669114396389.png

 

Shahbaz_analyst
8 - Asteroid
Spoiler
Shahbaz_analyst_0-1669114638110.png

 

NicolasSz
11 - Bolide

I did it with one single formula. I think the conversion with only one char for hours has been fixed cause the conversion simply work 

 

thanks

joshbennett
11 - Bolide
11 - Bolide

Did not think it made sense to use a macro for the solution, given a single Formula tool is all that is needed.

 

My solution:

Spoiler
joshbennett_0-1671515470581.png

 

gautiergodard
13 - Pulsar
Spoiler
Solution
zcahsyl
7 - Meteor

done

flavio-matos
7 - Meteor

My Solution - Macro

Spoiler
flaviomatos_0-1672309062272.png

 

lhalliwell
8 - Asteroid
Spoiler
Screenshot 2023-01-04 104843.jpg

carmenrapariz
8 - Asteroid
Spoiler
carmenrapariz_0-1672931875234.png