change time format
hello,
I have a record below and would like to change the time fromat from m:ss to mm:ss
input
00001,CUSTR,CUSTOMER,02310,N,0:00,0,0,0,0,0,0,0,0,0,0,0,0:00,0,0,0,0,0,CSH,
00001,CUSTR,CUSTOMER,02310,N,5:12,0,0,0,0,0,0,0,0,0,0,0,1:10,0,0,0,0,0,CSH,
output
00001,CUSTR,CUSTOMER,02310,N,00:00,0,0,0,0,0,0,0,0,0,0,0,00:00,0,0,0,0,0,CSH,
00001,CUSTR,CUSTOMER,02310,N,05:12,0,0,0,0,0,0,0,0,0,0,0,01:10,0,0,0,0,0,CSH,