Network Hours

[Bob Morris]

Hi,

I am looking for a fuction like networkdays but I would like the calculation
in work hours. For example, if something starts on Monday at 2:00pm and
finishes on Wednesday at 10:00am that would be 9 working hours. This should
also exclude weekends like networkdays. Does anyone know of such a
function?

Thanks,
Bob

 

[Chip Pearson]

Bob,

See the second formula at
http://www.cpearson.com/excel/datetimews.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com