Discussions

 View Only

  • 1.  Convert Multi Select Text to Duration

    Posted 06-16-2022 15:41
    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 06-16-2022 17:16
    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
    ------------------------------

    Original Message


  • 3.  RE: Convert Multi Select Text to Duration

    Posted 06-16-2022 17:25
    Excellent thank you Mark!  I think I'll probably create both numeric and duration fields - just in case.

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

    Original Message