Jeff,

"most phone companies list duration either as whole minutes or as decimal minutes with 6 second increments (1/10ths)."

Perhaps due to the fact that the system is working under EPOCH time, which is total seconds since January, 01, 1970, 12:00:00 AM.

I'm not sure how to incorporate this new code into the entire select statement right now, but I will start testing ways to do it.

Thanks, BPH

Good one. I was looking for something like this to compare two datetime values and return the delay in the format HH:MM:SS. This one really helped.

Thanks

__________________
- Vijay G