add time with out weekends

  • Thread starter Thread starter Aroldo
  • Start date Start date
A

Aroldo

Hi

I need to make a format where I just put a date and time and excel give me
the dates and times for each cicle, I now how to add the time but the problem
is that I dont work in weekends so I want that excel changes the date if
there is saturday or sunday in any cells to start over on monday.

What i have to do? place a pice in chamber for 16 Hrs,change the pice to
oven for 9 Hrs. Repeat cicle 5 times. I can do 3 cicles one week and 2 cicles
in an other one.

You have to excuse me bad english.


IN TIME OUT TIME
Camber Mon, Nov 19, 03:00 PM Tue, Nov 20, 07:15 AM
Oven Tue, Nov 20, 07:30 AM Tue, Nov 20, 04:30 PM
Camber Tue, Nov 20, 04:45 PM Wed, Nov 21, 09:00 AM
Oven Wed, Nov 21, 09:15 AM Wed, Nov 21, 06:15 PM
Camber Wed, Nov 21, 06:30 PM Thu, Nov 22, 10:45 AM
Oven Thu, Nov 22, 11:00 AM Thu, Nov 22, 08:00 PM
Camber Thu, Nov 22, 08:15 PM Fri, Nov 23, 12:30 PM
Oven Fri, Nov 23, 12:45 PM Fri, Nov 23, 09:45 PM
Camber Fri, Nov 23, 10:00 PM Sat, Nov 24, 02:15 PM
Oven Sat, Nov 24, 02:30 PM Sat, Nov 24, 11:30 PM


C16=specifc date an time =TIME(16,15,0)+C16
=TIME(0,15,0)+D16 =TIME(9,0,0)+C17
=TIME(0,15,0)+D17 =TIME(16,15,0)+C18
=TIME(0,15,0)+D18 =TIME(9,0,0)+C19
=TIME(0,15,0)+D19 =TIME(16,15,0)+C20
=TIME(0,15,0)+D20 =TIME(9,0,0)+C21
=TIME(0,15,0)+D21 =TIME(16,15,0)+C22
=TIME(0,15,0)+D22 =TIME(9,0,0)+C23
=TIME(0,15,0)+D23 =TIME(16,15,0)+C24
=TIME(0,15,0)+D24 =TIME(9,0,0)+C25
 
If I understand you correctly, look into this approach. Say E11 has a date
you want to reference in another cell, but change it to the following monday
if it falls on either Saturday or Sunday.

=IF(WEEKDAY(E11)=1,E11+1,IF(WEEKDAY(E11)=7,E11+2,E11))

the weekday function returns 1-7 referring to the day of the week. 1=Sun,
7=Sat.

WEEKDAY(E11)=1,E11+1 says that if E11 falls on Sunday, add 1 to the date,
making it Monday

WEEKDAY(E11)=7,E11+2,E11 says that if e11 falls on Saturday, add to to the
date, making it Monday
 
You could also look at the WORKDAY function which is aprt of the Analysis
ToolPak add-in

=WORKDAY(E11-1,1)

would Give the next weekday after E11 if E11 is a Sat or Sun
 
Back
Top