Difference between dates and time

Hi daddylonglegs

Thanks for the code it works perfectly.

Originally Posted by 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")