Additional Info


  • Hot Topics

Excel Count working hours between 2 dates excl weekends either with formula or function

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:

  • Excel
  • Microsoft Excel