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 calculate the difference in hours between a date/time range
but only the hours in a certain range.

1/27/10 4:49 1/27/10 11:32

I am trying to find the diff in hours only between 6:00 and 23:59, 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!