How to convert Duration to numeric ?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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? 
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Have you tried using the ToNumber([Duration_Field_A]) in the calculated column?
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb
Yes, ToNumber only has text and boolean as argument. Doesn't work. 
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
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?
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
If so ToDays() returned 5 in the formula numeric field.