convert value tu second

[#1]

Hello,

i would like too convert a nummeric feld to add to a date.

I have two column

Column one  is al value 35 and column is a date with time.  The value 35 must be add too date in second´s.

Can anyone help me, how must i do to get the right date

31.12.2016 12:30:13 + 35 second´s

are 31.12.2016 12:30:48

Thank´s for your help

[Vegar]

Interval( TimeColumn + interval#(secondsColumn, 's') ) as NewTime

[sunny_talwar]

Two options

TimeStamp(Date + Seconds/(60*60*24))

or

TimeStamp(Date + Interval#(Seconds, 'ss'))

[sunny_talwar]

Here is a tested sample

=TimeStamp(Date#('31.12.2016 12:30:13', 'DD.MM.YYYY h:mm:ss') + 35/86400)

[#5]

Good Mornig,

thank´s the formel is the super.  What does 60*60*24 mean?

[tresesco]

1 day = 24*60*60 seconds

[Vegar]

60 seconds, 60 minutes, 24hours. It's used for converting days to seconds one second equals 1/(60*60*24)

[#8]

Okay,

Thank you very much

[sunny_talwar]

If you got what you wanted, please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny