Difference between dates and time

[jns]

I have tried the following code =NETWORKDAYS(A2,B2)-1-MOD(A2,1)+MOD(B2,1)

I have 2 dates and times eg.05/09/2010 07:00 (A2) and 11/09/2010 21:00 (B2) I need to caculate the time in days and hrs between the two dates eg. ( 6 days and 14 Hrs) would that be possible to write such an code, and if so could you please assist, the above code I think display minutes only-not sure.
Many thanks in advance

[daddylonglegs]

Hello jns, thanks for changing your thread title.

The NETWORKDAYS formula is designed to count working hours/days only, for your example it looks like you want to count all the time. Try this formula

=INT(B2-A2)&" days "&TEXT(B2-A2,"h:mm")

[jns]

Hi daddylonglegs

Thanks for the code it works perfectly.

Hello jns, thanks for changing your thread title.

The NETWORKDAYS formula is designed to count working hours/days only, for your example it looks like you want to count all the time. Try this formula

=INT(B2-A2)&" days "&TEXT(B2-A2,"h:mm")