Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have some sample data that looks like this:
EnquiryID | CallDateTime | EnquiryDuration(Seconds) |
2323232323 | 22/06/2017 23:32:57 | 254.8 |
I need to calculate the end time based on the two fields above.
The EnquiryDuration field values range from a few seconds to hours.
How can I calculate and add the EnquiryDuration value to the CallDateTime field and create a CallEndTime field please?
=Date( CallDateTime + ( EnquiryDuration / 86400 ) , 'DD/MM/YYYY hh:mm:ss')
86400 is the number of seconds that there is in a full day when it comes to how datetime values do math.
From the online Qlik Sense help manual pages:
Date and time values are based on a date-time serial number that equals the number of days since December 30, 1899. The integer value represents the day and the fractional value represents the time of the day.
Read more here: Date and time functions ‒ Qlik Sense