=Networkhours type formula problem

Hello,

I am doing KPI's for my company and need to calculate the number of work hours between 2 date time entries.
I have had a search and found this formula:

=(NETWORKDAYS(M40,N40)-1)*("17:00"-"08:00")+MOD(M40,1)-MOD(N40,1)

However this returns a negative value


This is how I get the dates:

1/08/2015 12:45 - 2/08/2015 12:27

Work hours are 8 - 5 so It should return 8.7
if it is possible to exclude weekends this is great but no biggie if you can't.

Thanks for the help

A small change to the formula should do it.

=((NETWORKDAYS(M40,N40)-1)*("17:00"-"08:00")+MOD(M40,1)-MOD(N40,1))*-24

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Originally Posted by David A Coop

A small change to the formula should do it.

=((NETWORKDAYS(M40,N40)-1)*("17:00"-"08:00")+MOD(M40,1)-MOD(N40,1))*-24

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hello Gappy,

Did you receive this? For some reason FlameRetired picked it up, and they were not even in the thread!

DAC