Calculation work only on weekdays and not weekends

1. Calculation work only on weekdays and not weekends

For my work I need to calculate workhours from 00:00 to 7:00 and from 19:00 to 24:00.

The hours from 7:00 to 19:00 o’clock should not be calculated. On weekdays ( Monday to Friday) he’s does calculate it perfectly, but whene I will calculate the hours who are made in a weekend ( Saturday and Sunday) does the code not working

I have attached an example where you can clearly see that the workdays will be calculated and not the weekend

In the example, I have also inserted a text field, where I think the code give’s an error.
``Please Login or Register  to view this content.``
Maybe someone has an idea where or why the code goes wrong when it is calculated in a weekend.

Thanks

paul

2. Re: Calculation work only on weekdays and not weekends

If you just want the same calculation across all 7 days then remove the IF part of the formual

``Please Login or Register  to view this content.``

3. Re: Calculation work only on weekdays and not weekends

Sorry pjwhitfield, this code give's an error, but thanks any way

Originally Posted by pjwhitfield
If you just want the same calculation across all 7 days then remove the IF part of the formual

``Please Login or Register  to view this content.``

4. Re: Calculation work only on weekdays and not weekends

U r using weekday limit <6

correct it there

ALS(WEEKDAG(E10;2)<8

good luck

5. Re: Calculation work only on weekdays and not weekends

That code "ALS(WEEKDAG(E10;2)<8" is working, but whene there is no date ( E10) recorded , he will calculated automatic 7:00 hours. but he may only calculate hours if there are filled a date and a start and end time

6. Re: Calculation work only on weekdays and not weekends

TRy this:

=MAX(0;MIN(\$V\$7;I10)-MAX(\$T\$7;G10))

7. Re: Calculation work only on weekdays and not weekends

Originally Posted by paulvanrijn
Sorry pjwhitfield, this code give's an error, but thanks any way
it works fine for me but I think IndiRa is right, your regional settings must use ; instead of ,

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1