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

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.

U r using weekday limit <6

correct it there

ALS(WEEKDAG(E10;2)<8

good luck

Hello adm.patrikpl,

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

TRy this:

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

I think is about your regional settings...