topic Re: How to calculate the EnquiryEndTime based on EnquiryDateTime + Duration field? in App Development

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

mwallman — Fri, 03 Nov 2017 23:41:15 GMT

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?

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

petter — Sat, 04 Nov 2017 06:24:41 GMT

=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.