Custom Function to Change Character field to TIME

ThDon

Forums

Hi Guys,
Please help me with a function that can convert a Character field to a Time field, i have attached the file withe the time stored as character.

Brian Element Sun, 05/17/2015 - 17:23

Hello and welcome to the site.

I created custome function (attached) that will take the items that have an am or pm and normalize them in a 24 hour clock.  Theu use the @ctod command to change them to a time field such as:

@Ctot(#timeConversion(TIME), "HH:MM:SS")

Thanks for the example, that helped out.

Brian