I'm wondering if someone has a formula that will compute "Net Work Hours". I use the =NETWORKDAYS formula to compute the number of days a project takes from start to finish but, when two projects take exactly the same number of hours, but the finish extends even 9 minutes into the next day the results differ by a day. For example:
Project____Start_______________Finish_____________Days to complete
Project A: "8/20/09 11:42 AM" to "9/1/09 12:56 PM" = 9.0 days
Project B: "8/20/09 11:55 AM" to "9/2/09 12:09 AM" = 10.0 days
(Sorry this matrix is hard to read.)
Project____Start_______________Finish_____________Days to complete
Project A: "8/20/09 11:42 AM" to "9/1/09 12:56 PM" = 9.0 days
Project B: "8/20/09 11:55 AM" to "9/2/09 12:09 AM" = 10.0 days
(Sorry this matrix is hard to read.)