Quickbase Discussions

 View Only
  • 1.  Convert Multi Select Text to Duration

    Posted 15 days ago
    Hi All,
    I have a multiple choice text field with the below options for users:
    15 min
    30 min
    45 min
    60 min
    90 min

    What function can I use to obtain a Duration Value that corresponds with the user selection?  I need to be able to determine things like averages and totals using the duration value.

    Thanks in advance


    ------------------------------
    Troy MacPherson
    ------------------------------


  • 2.  RE: Convert Multi Select Text to Duration

    Posted 15 days ago
    I personally prefer to have numeric fields for the units in minutes

    For a numeric field type you can create a new formula numeric of 

    ToNumber(Left([multiple choice text], " "))

    If you want to have a formula duration field type then it would be 

    Minutes(ToNumber(Left([multiple choice text], " ")))

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Convert Multi Select Text to Duration

    Posted 15 days ago
    Excellent thank you Mark!  I think I'll probably create both numeric and duration fields - just in case.

    ------------------------------
    Troy MacPherson
    ------------------------------