adding seconds to a time in load editor

[danaleota1]

Hello,

I am trying to create a new field that takes the duration in seconds and adds it to my time field to get a new end time.  How do I get the new time below with the first two fields.  So far I used something like:

time(date) + duration/86400    but I don't think this worked.  Thanks. 

time(date)	duration (in seconds)	new time
12:00:25 AM	79	12:01:44 AM

[Vegar · Accepted solution]

Your sample looks correct or am I missing something? You might want to put time around the expression to get a better presentation of the value.

Time(time(date) + duration/86400) 

[danaleota1]

Hi Vegar,

I added that last time() around the entire expression and tested it the field is now showing the correct time format. Thank you!