topic Adding an integer to time(minutes) in QlikView

Adding an integer to time(minutes)

Fri, 01 Jul 2011 15:08:27 GMT

Hi, does anyone know how to add an integer to time field (minutes)?

The problem is Operating time is a whole number e.g. 248 and although Session time appears as a whole number e.g. 342 session time is actually be used as a decimal e.g..

---------------------

My formula is the following:

Touch Time Utilisation = Operating time / Session Time

Operating time = SUM ([OP TIME])

Session Time = INTERVAL(sum(TIME([Enter Rec])) --sum(TIME([Start Anaes])),'mm')

---------------------

The image attached illustrates the table im working with.

The desired result for date '4/1/2011' should be 248 / 342 = 0.725. But the result im getting is 1044.21052631579

Any ideas????

Adding an integer to time(minutes)

nagaiank — Fri, 01 Jul 2011 15:42:40 GMT

Try to find out how these values are stored internally before applying any format conversion.

For example, the session time of 342 in the top is minutes while the corresponding time of 0.2375 in the botton display is in hours (as 342/24/60 = 0.2375). Also 248/0.2375 = 1044.21

Hope this helps to fix your application.

If you need more help, attach your qvw file.

Adding an integer to time(minutes)

Fri, 01 Jul 2011 15:54:19 GMT

Hi Krishna, yes it seemed that the session time was indeed being converted to hours.

I solved it by multiplying the decimal time by 1440 (total minutes in 1 day)