Discussion board where members can get started with QlikView.
Time in minutes:
(Frac(Time1) - Frac(Time2)) * 1440
Time in seconds:
(Frac(Time1) - Frac(Time2)) * 1440 * 60
View solution in original post
There are 176 days between these two timestamps. Are you sure the simple difference in minutes is meaningful?
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')