Hi Everyone   
      
   I have an odd question for SQL   
      
   I'm trying to do a calculation on 2 date fields.  I'd like to get the exact   
   difference in time between 2 dates but I don't want to include any time if the   
   duration falls over a weekend.  For example, find me the difference in time   
   with the following but    
   don't include any time after Friday at midnight to Sunday at midnight.   
      
   StartDate = 03/14/2014 12:09:00pm   
   EndDate = 03/17/2014 09:24:00am   
      
   Or even more seemingly complex...   
      
   StartDate = 03/14/2014 12:09:00pm   
   EndDate = 03/24/2014 09:24:00am   
      
   Best Regards,   
   Andy   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)