add time with out weekends




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.

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

Flick Olmsford

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.


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

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question