Question

Adding Two Time Fields

  • 17 April 2019
  • 1 reply
  • 2 views
A

Hello,

I am looking to combine two time fields to create a new column output. I've tested a lot of functions and time formats but can't seem to get it right so maybe someone in the FME Community can help.

 

 

My first field is a specific time of day (departure_time), and I would like to add a second time field (travel_time) to achieve a final column with arrival_time.

departure_time and travel_time were originally in %H:%M:%S, will I need to convert these formats prior to a calculator? is calculation between two time fields even possible?

Any help would be much appreciated!

1 reply

erik_jan
Rank
Userlevel 2
Badge +12

Have a look at the DateTimeCalculator transformer.

That should be able to do these calculations.

Maybe the DateTimeConverter is useful, but I think that should not be necessary.

Hope this helps.

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
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.