| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the total overlapping time of multiple tasks, excluding non-working times | Excel Worksheet Functions | |||
| adding up times x occurs, excluding if y repeats in a different co | Excel Discussion (Misc queries) | |||
| Timesheet Calculate Sunday times that changes every month | Excel Discussion (Misc queries) | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| Calculating Averages but excluding zero's | New Users to Excel | |||
Threaded Mode
