cancel
Showing results for 
Search instead for 
Did you mean: 

Adding Time and seconds / Converting Seconds to Time

SOLVED
AlexL
Meteor

Question –

How do I get Alteryx to add time & seconds?

 

Field one has a start time (Excel Format- H:MM:SS AM/PM)

Field two has a duration in seconds. (Excel format- SSS)

 

Excel Solution-

  1. Divide Duration (Sec)/86400
  2. Convert the format to time
  3. Add Start Time with Duration (Time)

 

Problem –

Is it possible to get this solution in Alteryx?

 

Sample –

 

Field 1

Field 2

End Result

Start Time

Duration (Sec)

End Time

9:00:00

300

9:05:00

9:05:00

60

9:06:00

 

 

 

Quasar
Quasar

Generally, we would think an expression like:

DateTimeAdd([Start Time],[Duration (Sec)],"seconds")

would be what you are looking for, but that will error out if [Start Time] is a Time data type.

 

We need to first to make it look like a DateTime data type, and then we can use the DateTimeAdd() function. Something like:

DateTimeAdd(DateTimeToday()+" "+[Start Time],[Duration (Sec)],"seconds")

works in the attached, and notice the data type of the output column is Time in the attached.

 

As long as a string is in the Alteryx DateTime format "%Y-%m-%d %H:%M:%S", Alteryx can use it as a DateTime data type.

AlexL
Meteor

Exactly what I needed!

Thank you!