>>>>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.
If it's not broken, fix it until it is.
My Blog