Custom Function to Change Character field to TIME

3 posts / 0 new
Log in or register to post comments
Last post
Sun, 05/17/2015 - 12:44
#1
ThDon
Offline
Joined: 05/17/2015 - 11:59
Custom Function to Change Character field to TIME

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.

Images: 
Files: 
Office spreadsheet icon The file with the time stored as character
Top
Sun, 05/17/2015 - 17:23
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

Files: 
Binary Data timeConversion.ideafunc
Top
Wed, 05/27/2015 - 02:38
ThDon
Offline
Joined: 05/17/2015 - 11:59

Thanks Brian, I will try it out and revert.
Don

Top