View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dean Dean is offline
external usenet poster
 
Posts: 93
Default removing weekends

I am only wanting to count the hours between two dates that fall on Monday
thru Friday. In other words, I want to always exclude counting hours on
Weekends

The data is in the format of
6/27/06 12:10 - say that this is in cell A1
7/20/06 09:34 - say that this is in cell B1

=B1-A1
How do I do this ?
Thx for your assistance, it is much appreciated
- Dean