business hours formula help

  • Thread starter Thread starter Belinda7237
  • Start date Start date
B

Belinda7237

I have used this formula:

=(NETWORKDAYS(D14,E14-1)*8+(MOD(E14,1)-MOD(D14,1))) to calc the time between
start and stop considering an 8 hr business day.

the problem is that i am getting a negative if the start and stop is in the
same day.

I have also tried to add a *24 at the end still no good.

What am i doing wrong?
 
The problem is in your NETWORKDAYS()
Try this =if(d14=e14,0,networkdays(d14,e14-1)*8+....

Does this get you what you want?

You may want to add logic to make sure e14 is never less than d14.....
 
Back
Top