8 Replies Latest reply: Dec 2, 2016 5:13 AM by Sunny Talwar

# convert value tu second

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

• ###### Re: convert value tu second

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

• ###### Re: convert value tu second

Two options

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

or

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

• ###### Re: convert value tu second

Here is a tested sample

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

• ###### Re: convert value tu second

Good Mornig,

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

• ###### Re: convert value tu second

1 day = 24*60*60 seconds

• ###### Re: convert value tu second

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