View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ls111248 ls111248 is offline
external usenet poster
 
Posts: 1
Default Calculating Turn Around Times excluding Sunday

I need to track turn-around-times, date & time, excluding Sunday. The end
result needs to be the number of dates to completion. In this case the result
should be 4.25.
What I have currently is:
D76 E76 has Formula F76
Date Started Date Completed Number of Days to
Complete
5/12/2010 8:00 AM 5/17/2010 14:00 PM =IF(E76-D76<=0,"",E76-D76)

The formula I'm using does not exclude Sunday. I also receive a #VALUE
error when E76 is empty if I try to add -1 to the formula. (I'm using Excel
2007)