Networkdays Function returns incorrect result: Please help

[Fi_Mac]

Hello

I am trying to calculate the number of days, hours and minutes between two cells, for example the cell contents are as follows:

23/9/2014 10:00 (cell D76)

and

01/10/2014 0:00 (cell E76)

my formula/calculation is as follows:

=NETWORKDAYS(E76-D76,0)&" Days "&HOUR(MOD(E76-D76,1))&" Hour "&MINUTE(MOD(E76-D76,1))&" Minutes"

The result should be 5 days, 14 hours and 0 minutes, however, the result I get is

-5 Days 14 Hour and 0 Minutes

The formula works great apart from the fact that it should NOT be minus - can anyone assist me in where I am going wrong here please. I am using Windows 7, Excel 2010. Many thanks in anticipation of any help.

 

[Jonmo1]

This part
NETWORKDAYS(E76-D76,0)
should be
NETWORKDAYS(D76, E76)

 

[Fi_Mac]

fabulous, that worked, thanks very much

 

[Jonmo1]

You're welcome.

 

[barry houdini]

Doesn't that change make the answer 7 days, 14 hours, which is incorrect?

I think you need to subtract 1.....and make a further subtraction if the time in the start cell is greater than the time in the end cell. This formula should work consistently as long as D76 and E76 are not at the weekend

=NETWORKDAYS(D76,E76)-1-(MOD(D76,1)>MOD(E76,1))&" Days "&TEXT(E76-D76,"h"" hours ""m"" minutes""")

 

[Fi_Mac]

hello, yes it did, duh I never noticed that! Let me try your suggestion, thanks for posting

 

[Fi_Mac]

that's it fixed now it reads '5' rather than '-5', many thanks