Convert Multi Select Text to Duration

Question

Hi All,I have a multiple choice text field with the below options for users:15 min30 min45 min60 min90 minWhat 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------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community