Remove Colin from time stamp

[nickrosen28]

Hi all,

I ahve the belwo set and want to remove the ":" and the last 2 digits (seconds) from the time.

Also have some time that is 1 digit for the hour "8" instead of "08".

13:03:17, 8:02:33, 8:22:52, 13:26:26

Thanks for any help

[sp210708 · Accepted solution]

You can use the DateTime Tool to manipulate the format,

In this example I used the first tool to convert it to a date and fix the issue to address the "08"

The second tool converts it back to a string and puts in a custom format removing the ":" and removing the seconds,

Please mark this as an acceptable solution,