Hey all, I know I can find the answer to my question on quite a few places but I've tried most I find and they just don't work. Don't mind if its a formula or function though. example of what I tried for example is: =IF(NETWORKDAYS(A1,B1)=1,(MIN(Z1,MOD(B1,1))-MAX(Y1,MOD(A1,1))),(NETWORKDAYS(A1,B1)-2)*(600/1440)+(Z1-MAX(MOD($A$1,1),Y1))+MIN(MOD($B$1,1),Z1)-Y1) A1 is start time B1 is stop time
This question generated 23 answers. To proceed to the answers, click here.
This thread is current as of September 25, 2014.
For more resources for Microsoft Excel:
This article includes the following tags: