Problem with NetworkDays ... Inconsistent results

Joined
Feb 18, 2015
Messages
6
Reaction score
0
The Excel NetworkDays function is returning inconsistent results.

The Start and End dates for both examples below are less than 24 hours apart. In one case Networkdays () returns 1 and in the other it returns 2. Any ideas on why it's not consistent or what I can do or what I'm not doing?

Start Date End Date Networkdays Difference in Hours
01/25/2015 09:27:15 PM 01/26/2015 02:28:04 PM 1 17.01361111
01/28/2015 08:34:30 AM 01/29/2015 02:08:57 AM 2 17.57416667

Thanks,
Ronald
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top