business hours formula help
 

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?

business hours formula help
 

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

"Belinda7237" wrote:

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?

business hours formula help
 

Try like this:

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


"Belinda7237" wrote:

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?

business hours formula help
 

Hello,

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

Regards,
Bernd