topic Re: diference between times in QlikView

diference between times

rcandeo — Fri, 29 Nov 2013 13:54:57 GMT

I know that has a lot of posts, but I could not find one that helped me really.

I have two time fields, format hh:mm:ss and I only the diference between them in minutes please.

hour2 - hour1 = x minutes

Thank You

Re: diference between times

datanibbler — Fri, 29 Nov 2013 13:58:49 GMT

Hi Robson,

I haven't tried yet, but I guess you can calculate with time_fields just like you can with date_fields,

>>> hour2-hour2 <<<

Use the TIME() function to specify in which format you want the result.

HTH

Best regards,

DataNibbler

Re: Re: diference between times

Anonymous — Fri, 29 Nov 2013 14:04:35 GMT

Robson

Look like you are in need of the Interval() function.

The interval function formats the expression as a time interval according to the string given as a format-code. If the format code is omitted, the time format set in the operating system is used. Intervals may be formatted as a time, as days or as a combination of days, hours, minutes, seconds and fractions of seconds.

The QV Desktop Help gives a good description of its parameters, after the bit I have pasted in above.

Best Regards, Bill

Re: diference between times

rbecher — Fri, 29 Nov 2013 14:14:02 GMT

Just use time#() function and multiply by 1440:

=(time#('11:12:13') - time#('10:11:12')) * 1440

- Ralf

Re: diference between times

rcandeo — Fri, 29 Nov 2013 15:32:59 GMT

This is what I was waiting for. Thank you very very much