topic Re: Adding hours together in QlikView

Adding hours together

Fri, 23 Aug 2013 08:51:28 GMT

Hi there,

I am having difficulty adding hours together.

I have two feilds with the number settings set to 'time'.

This allows me to see the data in hours and minutes.

I am calculating the amount of hours each employee is logged in during a day.

I then want to add all of these hours together to get the total hours worked for the week.

However, when an employee works over 24 hours in one week, the clock seems to start back to zero.

For example, if an employee works 22 hours one day and 3 hours the next, the result is 1 hour.

Is there a way to make QlikView calculate this so that in the example above, i would get 25 hours instead of 1?

I would great;y appriciate some help with this.

Thanks

Brice-SACCUCCI — Fri, 23 Aug 2013 08:57:52 GMT

Hi,

can you provide a sample of the data or a basic QlikView app?

Date and time questions really depend on the format of the data.

Thanks,

Brice

Fri, 23 Aug 2013 11:04:28 GMT

Hi Brice,

Please find sample data attached.

Thanks Sorcha

Gysbert_Wassenaar — Fri, 23 Aug 2013 11:21:51 GMT

Try something like this:

LOAD Station,

[Time On],

[Time Off],

[Time Spent On],

[Time Spent On1],

interval([Time Off] - [Time On],'hh:mm:ss') as TimeSpentOn

FROM

[Sample Data.xls]

(biff, embedded labels, header is 1 lines, table is [Sheet1$]);