Fixing time entries.
FMPro Advanced 11; Mac OS
Okay... so I have a db with various time fields with several thousand records. Unfortunately, the data was imported from the old MS Excel files, the formats got all messed up. The actual numbers are still there, but the same field in various records might be displayed as:
This might be wishful thinking, but is there a way I can write a nice easy script that will go through all the records and fix them all to dilplay in the 02:34 format??