Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculate Time Difference

Hi,

I have a scenario like below,

StartTime     EndTime     

22:03:20       23:40:30     

23:45:33       00:12:30      

00:20:20       01:50:40      

I need to calculate the time difference between Start time and End Time.

Thanks in advance

Regards,

Leni

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

no, the 'mm' means that the difference will be shown in minutes. If you use 'hh:mm:ss' it will show it in hours, minutes and seconds


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

interval(EndTime-StartTime, 'mm')


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

If I mention like 'mm' whether it will return the minute value alone?? If so, then my requirement is something different

Startime = 15:52:36

EndTime = 15:52:41

Time Diff = 00:00:04

With this time difference I need to calculate this time in minutes, by converting hour, minutes and seconds in minutes which will be 0.07 mins

Thanks,

Leni

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

no, the 'mm' means that the difference will be shown in minutes. If you use 'hh:mm:ss' it will show it in hours, minutes and seconds


talk is cheap, supply exceeds demand