View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mpfirman mpfirman is offline
external usenet poster
 
Posts: 1
Default Business hours calculation

I would like to be able to calculate the difference between tw
dates/times but only count the business hours. For instance for an
hour day 1/2/04 08:00 - 1/1/04 08:00 would equal 8 hours. I previousl
was doing this with a formula using the NETWORKDAYS function but woul
like to re-write the entire spreadsheet using VBA. Any help o
suggestions would be appreciated. Thank you

--
Message posted from http://www.ExcelForum.com