Formula for adding week-end "idle time" to date range

**bradlessard** · 02-10-2012, 09:50 PM

I have a set of date ranges for a production line that I need to adjust so that the 48 hours of idle time from Fri 23:00 to Sun 23:00 are added to the end date range.

Basically the week-ends are idle time for the production line so my end date needs to factor in that idle time and reflect the true end time (where a week-end is present in the date range of course).

i.e.

2/2/12 3:59 AM 2/2/12 8:20 AM
2/2/12 8:20 PM 2/3/12 12:41 AM
2/3/12 3:00 PM 2/6/12 10:09 AM

Thanks,
Brad

**protonLeah** · 02-10-2012, 11:12 PM

Subract the WEEKNUM of the project end date from the WEEKNUM of the start date and multiply the remainder by 2 to get the total number of weekend days. Add this to the project end date to get the corrected end date:
Edit: I did not account for crossing into a new year. The formula in F2 should be:
=E2+(52*(E2<D2))-D2