Hi All,
I have a data dump which I feed into Excel and part of the report is in Time Format 00:00:00. In some of the cell the report shows as :04 I need to build something that will bring this back as 00:00:04.
Can someone please help as I have to go through 3k+ cells to re format.
Kris
I have a data dump which I feed into Excel and part of the report is in Time Format 00:00:00. In some of the cell the report shows as :04 I need to build something that will bring this back as 00:00:04.
Can someone please help as I have to go through 3k+ cells to re format.
Kris