I regularly download a .csv file with my quarterly call details from BT.
I wish to confirm the cost of the calls per minute and have set up a spreadsheet for this.
The major problem is that BT format their time duration as 0000:00:00, which means that Excel does not recognise this. The only way I have managed to get round this is to manually remove the two leading zeros from the hours. My formulas then do the rest. No custom formatting has been successful.
I have thought of recording a macro. I would need to convert a whole column of say up to 200 rows. Is there a shorter way by specifying the range? I am not at all conversant with VB, so any guidance would be much appreciated.