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: 
mwallman
Creator III
Creator III

How to calculate the EnquiryEndTime based on EnquiryDateTime + Duration field?

Hello all,

I have some sample data that looks like this:

   

EnquiryIDCallDateTimeEnquiryDuration(Seconds)
232323232322/06/2017 23:32:57254.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?

1 Reply
petter
Partner - Champion III
Partner - Champion III

=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