Challenge #34: Date-Time Formatting

[Ruud]

If it's ugly and it works, it is still ugly.

[CaraI]

In Version 11.0 the Date-Time Parse tool was upgraded, making the need to use more than one tool obsolete for this challenge.  However, in the spirit of the weekly challenge, I did it both ways.

Spoiler

[kat]

Of course now possible with the regular date time tool, but I tried some Regex on it. Still a one tool solution :D

Spoiler

[OldDogNewTricks]

Solution attached.

[kelly_gilbert]

My solution is similar to many others!

Spoiler

I'm not sure why this required a macro. I'm guessing that the Date/Time Parse tool wasn't available at the time this challenge was posted? 

[MaxGiegerich]

"Advanced"? Didn't realise you could use regex as a delimiter in the text to columns tool. That will come in handy for sure!

[Kenda]

Spoiler

Much like @Natasha, I was confused by the fact that the instructions told us to create a macro. I saw an easy solution only using a Formula tool. Anyway, if I were required to make a macro, I would simply have an input, use the same Formula tool, and then output the result.

[danilang]

Nice and quick

Spoiler

Here's what's behind the clock face

Dan