Adding hours together

[#1]

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]

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

[#3]

Hi Brice,

Please find sample data attached.

Thanks Sorcha

[Gysbert_Wassenaar]

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$]);