>Does any one know of a function tha converts seconds to hh:mm:ss format. For example: 110 seconds would be 00:01:50.
>
>TIA,

As long as it's a one day period, the following should work:

LPARAMETER nElapsedSecs
LOCAL dRefPoint, cReturnString
dRefPoint = DTOT(DATE() ) + nElapsedSecs
cReturnString = PADL(ALLTRIM(STR(HOUR(dRefPoint),2)),2,'0') + ':' + ;
                          PADL(ALLTRIM(STR(MINUTE(dRefPoint),2)),2,'0') + ':' + ;
                          PADL(ALLTRIM(STR(SEC(dRefPoint),2)),2,'0')
RETURN cReturnString

You can get the number of days with TTOD(dRefPoint) - DATE(). You can speed it up slightly by using a date constant in place of DATE().