Forum Discussion

TroyMacPherson's avatar
TroyMacPherson
Qrew Cadet
3 years ago

Convert Multi Select Text to Duration

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
------------------------------
Formulas and functions
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years 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
    ------------------------------
    • TroyMacPherson's avatar
      TroyMacPherson
      Qrew Cadet
      3 years ago
      Excellent thank you Mark!  I think I'll probably create both numeric and duration fields - just in case.

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