work time

[Anonymous]

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

[sspe]

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

[Anonymous]

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

[Anonymous]

Hi,

I faced a similar problem...

Can Start and End time involve more than one day?

Can you share sample data?

Thanks,

Elena

[Anonymous]

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

[Anonymous]

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

[Anonymous]

MY problem is lunch time (see my last post)

Thanks in advance for your help

[Anonymous]

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.