Skip to main content
Question

Adding Two Time Fields

  • April 17, 2019
  • 1 reply
  • 15 views

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
Contributor
Forum|alt.badge.img+17
  • Contributor
  • April 17, 2019

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings