Time Formats

0

How do I fix the format of the time on data if the format is (A ":16" ) and the format should be (B "00:00:16") unfortunately when i extract the data it is given in this format.

Is there a way i can change A to B?

Thank you for your help Zain.

Answer
Discuss

Answers

0

Used find and replace...in FIND put A; then in REPLACE WITH put B.

Discuss

Discussion

Hi Thanks for this, B varies sometimes its a different value, the above is an example of on of many.
Zain Jul 15, '17 at 12:26 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login