Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
leni_balakrishn
Contributor III

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

Tags (1)
1 Solution

Accepted Solutions

Re: Calculate Time Difference

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
3 Replies

Re: Calculate Time Difference

interval(EndTime-StartTime, 'mm')


talk is cheap, supply exceeds demand
leni_balakrishn
Contributor III

Re: Calculate Time Difference

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

Re: Calculate Time Difference

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
Community Browser