Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota1
Creator
Creator

adding seconds to a time in load editor

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 AM7912:01:44 AM
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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) 

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Creator
Creator
Author

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!