I have entered comments in this sheet its alot different. I thought it
was working but it turns out it still wasn't giving me the proper actual
assembly time. i just can't figure out what is wrong with the main
formula
which again is
=IF(G2="","",(((NETWORKDAYS(F2,G2,$W$2:$W$22)-1)/3+MOD(G2,1)-MOD(F2,1)+((MOD(G2,1)<0.5)-(MOD(F2,1)<0.5))/48)/E2)).
in this sheet i split it up between
=IF(G2="","",(((NETWORKDAYS(F2,G2,$W$2:$W$22)-1)
split
/3+MOD(G2,1)-MOD(F2,1)+((MOD(G2,1)<0.5)-(MOD(F2,1)<0.5))/48)/E2)).
Hopefully this helps please let me know what else is needed.
+-------------------------------------------------------------------+
|Filename: FORMULA.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=94|
+-------------------------------------------------------------------+
--
nathanv3223
------------------------------------------------------------------------
nathanv3223's Profile:
http://www.thecodecage.com/forumz/member.php?userid=159
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=70839