Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoI 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
------------------------------
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
3 years agoQrew Cadet
Excellent thank you Mark! I think I'll probably create both numeric and duration fields - just in case.
------------------------------
Troy MacPherson
------------------------------
------------------------------
Troy MacPherson
------------------------------