I'm trying to calculate the number of weekdays between 1-27-2013 (cell h3) and 6-11-2013 (cell L3). I have the formula =networkdays(H3,L3) with no holidays. the problem is when I format the result cell as a number it gives me 97. When I try to format as dd:hh:mm it gives me 06:00:00. Can someone please explain this and how I can correct it so the format reads 97:00:00?
Thank You!
Bookmarks