topic Re: Calculation with minus times in time format in QlikView

Calculation with minus times in time format

neapicture — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I have to do an overtime evaluation and get a file with raw data. Unfortunately, the field hour is in text format (shown only as a time format) and there are also minus hours.

I have to make a buzz. Now probably the value would first have to be converted into decimal in order to be able to count / sum on the minus times. If possible, the result should again be in time format (hh: mm). (alternatively decimal).

Unfortunately, I do not really get the formula right.

Re: Calculation with minus times in time format

shiveshsingh — Wed, 14 Feb 2018 07:03:21 GMT

What do you mean by this value?

177:10

Re: Calculation with minus times in time format

neapicture — Wed, 14 Feb 2018 07:22:55 GMT

The employee has 177 hours and 10 minutes of overtime on his working time account

Re: Calculation with minus times in time format

shiveshsingh — Wed, 14 Feb 2018 07:37:15 GMT

and what this suggests?

-07:04

Re: Calculation with minus times in time format

neapicture — Wed, 14 Feb 2018 08:39:57 GMT

Well, the employee has 7 hours and 4 minutes minus in the account, so 7 hours too little worked

Re: Calculation with minus times in time format

lorenzoconforti — Wed, 14 Feb 2018 10:36:44 GMT

Please see the attachment. I've converted it to number of hours

I don't think you can have it expressed as hh:mm as time cannot be negative

Re: Calculation with minus times in time format

PrashantSangle — Wed, 14 Feb 2018 10:41:56 GMT

Hi,

what is your expected output.

Regards