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
Thanks in advance
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.
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
Thanks for your help.
What I've to face is the lunch time. The work time is something like:
8.30 till 12.30
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
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.