Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
MVP
MVP

Re: Exp Help

Time in minutes:

(Frac(Time1) - Frac(Time2)) * 1440

Time in seconds:

(Frac(Time1) - Frac(Time2)) * 1440 * 60

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

MVP
MVP

Re: Exp Help

>>175.98499988425

There are 176 days between these two timestamps. Are you sure the simple difference in minutes is meaningful?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
pratap6699
Contributor

Re: Exp Help

by differenciate time interals we use interval function

=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')