Adding a Zero in front of a copied time

[mheihn]

I am trying to copy information our of CentreVu into Excel. When I copy any time less than one minute Excel will not calculate it. Is there a way to write an if statement or something along those lines? Once I copy the information into the Excel workbook I would like to link it to another spreadsheet in that workbook.

Example:

Copied time :38

The linked cell gives me a value error. How do I change the :38 to 0:38 automatically?

Any help is appreciated.

Thank you,
Michael

 

[Oaktree]

Not too sure what you mean... maybe =TEXT("0:0"&A1,"mm:ss")?