>>>>>Anybody have a technique for measuring the amount of time it takes a function to process?
>>>>>
>>>>>I tried the following ... but that give me total seconds and I need the that result converted to hours:minutes:seconds.
>>>>>
>>>>>Other Suggestions? Ideas?
>>>>>
>>>>>nStart = Seconds()
>>>>>.
>>>>>(my code)
>>>>>.
>>>>>
>>>>>nStop = Seconds()
>>>>>
>>>>>nRunTime = nStop-nStart
>>>>>
>>>>>How to get nRunTime to look like HH:MM:SS??
>>>>>
>>>>>Help?
>>>>>
>>>>>Please and thanks.
>>>>
>>>>
>>>>? TTOC(DTOT(DATE())+nRunTime,2)
>>>
>>>Interesting- but only good for values > 1 hour and less than 24...
>>
>>What do you mean "> 1 hour"? It works with seconds. And you're correct it is only good for up 23:59:59. :) If you want to show days, that's another animal, but it can be done:
>>
>
>Only that for values of less than 3600, it displays 12:00, instead of 00:00...

OIC what the problem is now. If you SET HOURS TO 24, then the hour shows as 00:00:00. I'm sorry, I just find that an AM/PM time to be pretty useless, since I usually deal with operations that are 24/7 (or pretty close to that) and use military time. Sorry for the confusion, and thanks for reminding me of the 12/24 setting.