If you read whole thread you would know that it only applies when seconds < 86400. < VBEG >

>>I realized that it would produced desired result only if SET HOURS set to 24. Here's the code that will return correct result regardless of any date/time settings.

? TRANSFORM(RIGHT(TTOC( DTOT(DATE()) + lnSeconds,1),6), "@R 99:99:99")

>
>And if lnSeconds >= 86400? < beg >