Discussion Board for collaboration on QlikView Scripting.
I have a scenario like below,
I need to calculate the time difference between Start time and End Time.
Thanks in advance
Go to Solution.
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
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