var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Convert number to minutes
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.
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?
Thanks for reply
Thanks I'll try this out. Math is great - I'll second that opinion.
Last edited by al91206; 03-23-09 at 17:23.