Calculating Turn Around Times excluding Sunday

L

ls111248

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)
 
T

Teethless mama

A2: Start date
B2: Complete date

=IF(COUNT(A2:B2),SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(INT(A2)&":"&INT(B2))))>1))-1+MOD(B2,1)-MOD(A2,1),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Calculate the number of days to exclude Sunday & Holidays 6
How to calculate difference between two date & time along with working hours and days 2
Calculate the total overlapping time of multiple tasks, excluding non-working times 1
Date/Time Difference Excluding Weekends & Holidays 2
count how many staff are scheduled between... 4
Calculating date/time intervals?? 1
how many people are scheduled between... 0

Top