Workdays

[brettsouth]

I have a start date in cell A1 Formatted as 09-Aug-04_07:00:00

In cell B1 we have Machine days 3.5 formatted as number

I am chasing a formula which will supply into cell C1 what time the jo
finishes same fomat as cell A1.

The main criteria in the formula is that the standard work day operate
from 07:00:00 am through to 14:00:00 pm and the work week is only the
day week and the formula must include holidays.
The below formula does not appear to be working and the end resul
using it is #value!.
This formula makes no allowances for holidays!

(((INT(B1)-INT(A1)+1)*8/24)-IF(8/24 < MOD(A1,1),MOD(A1,1)-8/24-IF(12/2
< MOD(A1,1),MIN(MOD(A1,1)-12/24,1/24))-MAX(MOD(A1,1)-17/24,0))-IF(17/2

MOD(B1,1),17/24-MOD(B1,1)-IF(13/24

MOD(B1,1),MIN(13/24-MOD(B1,1),1/24))-MAX(0,8/24-MOD(B1,1))))*24

Can any one hel

 

[Frank Kabel]

Hi
do you always start at 07:00. If yes try the following formula:
=WORKDAY(INT(A1),INT(B1),list_of_holidays)+MOD(A1,1)+(MOD(B1,1)/24)*(7/
24)