M
Moony
Hi everyone
I have an error in my Excel formula in some cases but not the others (same
formula) and I just can't figure out the reason.
PLEASE help me.
Here is an example where I have the error message.
The formula:
=ABS(IF(INT(O543)=INT(P543),24*(P543-O543),(24*(DayEnd-DayStart)*(MAX
(NETWORKDAYS(O543+1,P543-1),0)+INT(24*(((P543-INT(P543))-(O543-INT(O543)))+
(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(((24*(P543-INT(P543)))-
24*DayStart)+(24*DayEnd-(24*(O543-INT(O543)))),(24*(DayEnd-DayStart))))))
gives #REF! as a result.
O543 is =F543-TIME(2,0,0) and F543 is 12/9/2009 10:52:00 AM
P543 is =H543-TIME(2,0,0) and H543 is 12/10/2009 10:41:33 AM
Can you see what the issue is?
Please help, many many thanks in advance
I have an error in my Excel formula in some cases but not the others (same
formula) and I just can't figure out the reason.
PLEASE help me.
Here is an example where I have the error message.
The formula:
=ABS(IF(INT(O543)=INT(P543),24*(P543-O543),(24*(DayEnd-DayStart)*(MAX
(NETWORKDAYS(O543+1,P543-1),0)+INT(24*(((P543-INT(P543))-(O543-INT(O543)))+
(DayEnd-DayStart))/(24*(DayEnd-DayStart))))+MOD(((24*(P543-INT(P543)))-
24*DayStart)+(24*DayEnd-(24*(O543-INT(O543)))),(24*(DayEnd-DayStart))))))
gives #REF! as a result.
O543 is =F543-TIME(2,0,0) and F543 is 12/9/2009 10:52:00 AM
P543 is =H543-TIME(2,0,0) and H543 is 12/10/2009 10:41:33 AM
Can you see what the issue is?
Please help, many many thanks in advance