Easy (I think) Excel question

[The Nr Fairy]

To make Whirlygig's suggestion more efficient, simply format the resulting cells as "date". You can then use them as time-formatted cells directly.

It does rely on every original cell having at least 6 characters, i.e. 12:34Z.