topic Re: Calculate Time Difference in QlikView

Calculate Time Difference

Anonymous — Wed, 03 Oct 2012 12:10:31 GMT

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

Gysbert_Wassenaar — Wed, 03 Oct 2012 12:21:57 GMT

interval(EndTime-StartTime, 'mm')

Anonymous — Wed, 03 Oct 2012 12:36:19 GMT

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 — Wed, 03 Oct 2012 12:55:20 GMT

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