Alastair, Thanks, that worked for what I'm trying to do.
David -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Alastair Burr Sent: Tuesday, July 06, 2010 5:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: converting real to time format Try this but watch out if you change days, that is, go past midnight: set var vStart time = 14:00:00 set var vEnd time = 18:00:00 set var vElapsed time = (AddSec(0:00:00, (vEnd - vStart) )) show var vElapsed If you are going over a date change then: set var vStartdt datetime = '20/06/2010 14:00:00' set var vEnddt datetime = '21/06/2010 13:00:00' set var vElapsed time = (AddSec(0:00:00, (vEnddt - vStartdt) )) show var vElapsed Regards, Alastair.
