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