business hours formula help

[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?

 

[Brad]

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.....

 

[Teethless mama]

Try like this:

=(NETWORKDAYS(D14,E14)-1)*("8:00")+(MOD(E14,1)-MOD(D14,1))

 

[Bernd P]

Hello,

Maybe my UDF count_hours can help you here:
http://www.sulprobil.com/html/count_hours.html

Regards,
Bernd