>I am using your function as shown above in a report. It is MUCH faster than anything I have tried to this point. Additionally, if you need to use it to average a column in the page footer you can use:
>
>? LEFT( TIM_FormatMilli( INT(ROUND(110.50,0)) * 1000 ),8 )
>
>Perhaps you can add a function that just does HH:MM:SS to focus?
>
>Thanks for your help,
I'll do that function for the next week. In fact, what I plan to do is to accept a second parameter. If this is passed, I'll format the string with HH:MM:SS instead of HH:MM:SS.ttt. Sounds good to you?
Pat