Hello,
On a previous thread, the formula below calculates the time difference between two times and dates excluding evenings and weekends:
=SUMPRODUCT(INT((WEEKDAY(B2-{2,3,4,5,6})+INT(H2)-INT(B2))/7),{"16:10","16:10","16:10","16:10","15:40"}-"8:00")+MOD(H2,1)-MOD(B2,1)-IF(WEEKDAY(H2)=6,"15:40","16:10")+"8:00"
Is it possible to have a similar formula that adds 10 hours onto a date and time taking into account working hours. For example you start a job at 14:00 but stop at 17:00 as the factory closes and restarts again at 06:00. The job would then finish at 13:00.
Thanks Mike
On a previous thread, the formula below calculates the time difference between two times and dates excluding evenings and weekends:
=SUMPRODUCT(INT((WEEKDAY(B2-{2,3,4,5,6})+INT(H2)-INT(B2))/7),{"16:10","16:10","16:10","16:10","15:40"}-"8:00")+MOD(H2,1)-MOD(B2,1)-IF(WEEKDAY(H2)=6,"15:40","16:10")+"8:00"
Is it possible to have a similar formula that adds 10 hours onto a date and time taking into account working hours. For example you start a job at 14:00 but stop at 17:00 as the factory closes and restarts again at 06:00. The job would then finish at 13:00.
Thanks Mike