Discussion Board for collaboration on QlikView Scripting.
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