Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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)
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)
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!