View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thomas T Thomas T is offline
external usenet poster
 
Posts: 1
Default Network days rounding off hours

I use Networkdays formula to calculate difference bwtween 2 dates,if the end
date is beyond 12 hours the formula returns 1, so my calculation of SLA is
going vague.
Is there any formula that we can use which will exclude weekdays and will
report in hours. Or is it possible in vba to do this cutom requirement