We have a column that gives us a number. That number is actually number of minutes for our call center.

We would like to display the number in a HH:MMS format if possible.

Any ideas - we were thinking of the EXTEND function, but I'm not getting the syntax correct.

Thanks!

Al

I'm not sure, if I understand, what are you trying.

If you have information only about minutes, how do you want to get information about seconds?

You're right! Sorry about that....

Here is a better and clearer explanation:

This is for a call center report. The columns come in as a number which indicates number of minutes - so that is fine. Then though we have calculated fields like Avg Call Answer Time, etc.

Then we'll have a decimal - like 5.9 and I would like to convert that to MMS - there won't be any results w/ hours so having hours display is not necessary. I think this makes more sense.

5.9::INT would be minutes (cast operator)
((5.9-(5.9::INT))*60)::INT would be seconds

Isn't math great?
HTH

Thanks I'll try this out. Math is great - I'll second that opinion.