View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Ratzel[_2_] Jon Ratzel[_2_] is offline
external usenet poster
 
Posts: 16
Default Subtracting Dates to get total time work time excluding weekends

I have two date columns formated like this:

1/22/08 2:19 PM

I need to subract them to get the total time but I need to exclude weekends
and hours not in the normal working day. If the start of the day is 8:30AM
and ends at 5:00PM, how do I get the total work time between the two dates?

Thanks, Jon