Skip to main content
  • EN

Hello - I have several fields in hh🇲🇲ss format and I want to sum the total number of seconds from all parts all the field.

 

For example:

01: 10: 30

would total 4230 seconds

 

Does anyone know the best way to achieve this?

 

I am brining the data in from an API and have used the JSONFragmenter to tabularise the data.

 

I assume the current data type for the fields is string as that's the default for FME?

This can be done using an AttributeCreator:

@DateTimeDiff(@Value(time),000000,seconds)

 

This can be done using an AttributeCreator:

@DateTimeDiff(@Value(time),000000,seconds)

 

Thank you so much! :)

Reply


Community Stats

30,364
Posts
115,373
Replies
38,148
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.