topic Re: work time in QlikView

work time

Anonymous — Thu, 30 Apr 2015 08:27:25 GMT

Dear all,

I'm trying to calculate the work time between two dates and I don't know to do it.

The work time calendar is like this:

Monday-Friday 8.30 - 12.30 14.00 - 18.00

By networkdays function I know the right work days, but I'm not able to calculate the work time

Help please

Thanks in advance

Stefan

Re: work time

sspe — Thu, 30 Apr 2015 08:53:09 GMT

If you know that you always have 8 work hours per day, then a simply solution would simply be to multiply no of workdays with 8.

If the working hours can vary, then you'll have to write a script that can calculate the workhours but how that will look will depend on how the workhours are stored. If it can vary per workday (If d.g. friday only have 7 hours), then you'll have to do some more complicated scripting and again this will depend on how your data are stored.

Regards

Steen

Re: work time

Anonymous — Thu, 30 Apr 2015 09:14:30 GMT

Hi Steen,

first of all thanks for your reply.

PErhaps I'm wrong, but I don't think that is so simple. For example:

Start time 28-04-2015 at 10.30 AM

End time 30-04-2015 at 17.00 PM

The total work time is : 5.30h (for 29th april) + 7h (on 30th april) = 12h 30m

It's too hard for me

Re: work time

Anonymous — Thu, 30 Apr 2015 13:13:17 GMT

Hi,

I faced a similar problem...

Can Start and End time involve more than one day?

Can you share sample data?

Thanks,

Elena

Re: work time

Anonymous — Thu, 30 Apr 2015 13:20:29 GMT

See if the attached helps. I created it recently for a similar question.

Re: work time

Anonymous — Thu, 30 Apr 2015 14:29:37 GMT

Thanks for your help.

What I've to face is the lunch time. The work time is something like:

8.30 till 12.30

lunch time

14.00 18.00

So, if the start time is 10.00 and the end time is 16.00 , for me the real work time is 4hours.

I really don't know how to solve it

Re: work time

Anonymous — Thu, 30 Apr 2015 14:30:41 GMT

MY problem is lunch time (see my last post)

Thanks in advance for your help

Re: work time

Anonymous — Thu, 30 Apr 2015 15:59:19 GMT

HI,

You should try to transform your date and hour into num

Then you will be able to calculate the difference between the two numerics corresponding to the starting and ending time.