This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
i have a log time table with employees clock-in and clock-out times.
i wish to convert it to a new structure which will show duration per day per amployee
Like this may be?
Note: If your in and out times come from different dates, you have to consider that dates as well in the calculation. May be creating a timestamp field separately concatenating time and date fields together.
hi, thanks for the quick reply!
looks like what i was looking for.
2 further questions, if i may:
(1) What if an employee clocked in and out few times on one day?
how do I handle this (in script, probably)?
(2) What about night shift employees? clocking-in on 21:30 (for example) and clocking out on 05:30 on the next day?
in this case i wish to show 2.5 working hours on the first day and 5.5 hours on the next day