Elapsed Time Calculation

[#1]

Hello !

I have 2 timestamp fields like this :

• Start Date and Start Time
• End Date and End Time

I need to calculate the elapsed time, in Seconds, amongst those TimeStamp pairs.

How do I do that ?

Thanks in advance for your support !

[jzimolong · Accepted solution]

Try checking this out:

http://community.qlik.com/thread/37536

[its_anandrjs]

Hi,

Try this if fields are in pure time stamp fields.

Interval( [End Time] -  [Start Time],'s' )

Or

Interval( [End Time] -  [Start Time],'ss' )

Regards

Anand

[MarcoWedel]

also possible:

(EndTimeStamp-StartTimeStamp)*86400

meaning: difference of the timestamps in days * seconds per day

hope this helps

regards

Marco

[#5]

Thanks 4 your help !

I have solved the issue.

Here are some lines showing the concept on a standalone script (QVW) of mine that I use as a 'laboratory' :

LET INTERVALO=INTERVAL(MAKEDATE(2015,01,15)-MAKEDATE(2015,01,01),'D hh:mm');

TRACE $(INTERVALO);

Thanks again !