I would like to pad a zero to the left of a time value if no number is already present to the left of the ":".
I am importing a lot of data from another application. The data is in the format [h]:mm:ss. However, when the time value is less than one hour, nothing appears to the left of the leading ":". (for example :05:12 for 5 minutes and 12 seconds.) When the value is above one hour, there is no problem (example: 2:34:12).
I need to have a leading zero so I can total the time values. Doing this manually is not an option due to the large volume of data.
Thanks for any help you can give.
Regards,
I am importing a lot of data from another application. The data is in the format [h]:mm:ss. However, when the time value is less than one hour, nothing appears to the left of the leading ":". (for example :05:12 for 5 minutes and 12 seconds.) When the value is above one hour, there is no problem (example: 2:34:12).
I need to have a leading zero so I can total the time values. Doing this manually is not an option due to the large volume of data.
Thanks for any help you can give.
Regards,