# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
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.

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