View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GMv1 GMv1 is offline
external usenet poster
 
Posts: 8
Default Calculating diff between date/ time only between certain hours

I am trying to find the diff in hours only between 8:00 and 17:00 Monday to
Friday only, any hours that fall outside of that time frame should not be
counted. Each calculation will have different dates so if there is a way to
do this without specifying the date that would be great!

2/19/2010 16:00 2/22/2010 9:00 ???

Thanks for any assistance you can offer!