Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    6

    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.

    Thanks!

    Al

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    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?

  3. #3
    Join Date
    Mar 2009
    Posts
    6
    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.

  4. #4
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    5.9::INT would be minutes (cast operator)
    ((5.9-(5.9::INT))*60)::INT would be seconds

    Isn't math great?
    HTH

  5. #5
    Join Date
    Mar 2009
    Posts
    6

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •