Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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')