>>>>>Wow <g>. I didn't even think of that. I need to learn to find simple solutions myself and not to bother people with my silly questions.
>>>>>Thank you very much.
>>>>
>>>>Don't worry, there is no problem to ask if you don't know something.
>>>>
>>>>BTW, if you want to format the difference so that it also appears as a DateTime value, you might add it to a midnight DT value. The date part, of course, would be irrelevant.
>>>
>>>No, I need the result in seconds (actually in hours which is easy to convert).
>>>Thank you very much.
>>
>>What's to convert?
>>
>>cTime = TTOC({^2005/01/01 00:00}+nSeconds,2)
>>
>>Take whatever portion of it you need with LEFT() or SUBSTR().
>
>Fred,
>
>I'm trying to figure out a simple algorithm to convert elapsed time to this format
>367 sec.
>00:06:07
>3607 sec.
>01:00:07
>
>e.g. convert lnSeconds to hh:mm:ss
>
>I have a quite complex code doing it, but I think it could be much simpler.
set hours to 24
set seconds on
lcElapsed = ttoc(ctot('0')+367,2)
Up to 11:59:59. Bigger values need a little tweak.
Cetin