(RTIME(INT(SGET(value,2,1)),INT(SGET(value,2,4)),0)) where 'value' is your text variable or column that does not represent seconds.
Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Castanaro, Bob Sent: Friday, November 14, 2008 5:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Convert text to time List, Having a brain freeze. Is there a way to convert text data values to time in a table. For example, I have two fields, one is time one is text data type. I need to do some math on this, and cannot remember if you can change the data type from text to time. The data is in time format 00:00 in both columns. Any ideas? Thanks Bob C Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [EMAIL PROTECTED] [cid:[email protected]]
