Hi Friends,

Need help in one of the excel sheet. I have like 40000 rows which is in time format. But in few fields i have in below format which is in time format includes other number format. I need to replace colon ":" in the first field in few rows. Obvious replace function will not work as it will remove all the columns. How can i remove first colon ":" and convert them in time field.

2:25:33
:49:18
0:05:00
:00:16
:00:05
3:22:00
:18:33
1:35:12
:59:04
3:03:56
2:38:34
3:10:45
:00:05
:03:09