I have searched this but I have not found a suitable answer yet, Here I have a field as below time "0" "7" "56" "101" "3045" "7034" These show a time stamp, 0 is 0 second, 56 is 56 seconds, 101 is 1m1s, 3045 is 30m45s. I would like to transform these to mm:ss format, so "0" would be "00:00", "101" would be "01:01". How I can do this?
... View more