Converting a duration time text field into a number

JaymeKnapp · 2024-11-22T00:47:12+00:00

There was an error rendering this rich post.

I have a field from NetSuite called duration, which is a measure of time in this format 8:30

This stands for 8 hours and 30 minutes of work time.

I need to convert it from a text to a number so I can create measure.

Thank you!

Jayme K.

Find more posts tagged with

Magic ETL

Try an Add Formula tile and the TIME_TO_SEC function:

name: duration_sec
expression:

TIME_TO_SEC(`duration`)

This should work as long as all your string values are in that hours:minutes format.

Thank you for the quick response! This work perfectly!

Try an Add Formula tile and the TIME_TO_SEC function:

name: duration_sec
expression:

TIME_TO_SEC(`duration`)

This should work as long as all your string values are in that hours:minutes format.

Thank you for the quick response! This work perfectly!