- 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
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: