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


--
Thanks!
Aroldo

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,E 11))

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






"Aroldo" wrote:

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


--
Thanks!
Aroldo

It helps me very much

Thank you Flick!!

Aroldo


"Flick Olmsford" wrote:

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,E 11))

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






"Aroldo" wrote:

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


--
Thanks!
Aroldo

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

"Aroldo" wrote:

It helps me very much

Thank you Flick!!

Aroldo


"Flick Olmsford" wrote:

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,E 11))

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






"Aroldo" wrote:

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


--
Thanks!
Aroldo