Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

work time

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

7 Replies
Highlighted
Creator II
Creator II

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

Highlighted
Creator II
Creator II

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

Highlighted
Specialist
Specialist

Hi,

I faced a similar problem...

Can Start and End time involve more than one day?

Can you share sample data?

Thanks,

Elena

Highlighted
Champion III
Champion III

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

Highlighted
Creator II
Creator II

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

Highlighted
Creator II
Creator II

MY problem is lunch time (see my last post)

Thanks in advance for your help

Highlighted
Creator III
Creator III

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.