I need a macro that will only find formats mm:ss and not format hh:mm:ss and then convert mm:ss to hh:mm:ss.
For example:
Calculation'S
01:00:03
01:00:54
01:03:27
58:46
It searches each and then only finds the 58:46 and then converts it by taking 58:46/60 and giving 00:58:46. I need to do this since some are in hh:mm:ss format, while others are in hh:mm format. Unless there is an easier way to convert just the mm:ss format - and right clicking and formating isn't working.
For example:
Calculation'S
01:00:03
01:00:54
01:03:27
58:46
It searches each and then only finds the 58:46 and then converts it by taking 58:46/60 and giving 00:58:46. I need to do this since some are in hh:mm:ss format, while others are in hh:mm format. Unless there is an easier way to convert just the mm:ss format - and right clicking and formating isn't working.
