How to convert Duration to numeric ?

Question

I have a field duration which collects data in minutes using smart units. I want to convert this duration to numeric field so I can use it in a calculated column to compute pace?

I tried using the function ToNumber but it doesnt validate the argument. Is there any other way?

chuckgrigsby · Answer

Have you tried using the ToNumber([Duration_Field_A]) in the calculated column?

rajhelaiya · Answer

Yes, ToNumber only has text and boolean as argument. Doesn't work.&nbsp;

chuckgrigsby · Answer

Ah you're right. I tried a duration field, entered 5, returned 5 days. then in a formula numeric field used ToText() and it returned 120. Assuming you want 5 to return?

chuckgrigsby · Answer

If so ToDays() returned 5 in the formula numeric field.&nbsp;

Forum Discussion

How to convert Duration to numeric ?

Related Content

Convert Duration to Numeric

Converting delimited text into checkboxes

Convert yes/no multiple choice to numerical value?

Formula-Numeric Field Returning Null Instead of 0

IF statement changing numeric to text