=IF(OR(WEEKDAY(C3+B3)=7,WEEKDAY(C3+B3)=1),C3+B3+2, C3+B3)

Assuming you just wanted to add two more days if the finish date fell on the
weekend, this should give you what you want...

"notanexcelguru" wrote:

I am trying to create a schedule for a machine. I know how much of a day
each job will take. When I use a formula to just add column b to c, the
result actually includes the hour of the day, but I need to exclude the
weekend. When I use workday function then the fraction of the day seems to
not be included in the calculation. Is there a way to combine these
functions to add a portion of a day only using the work week?






B C b+c workday function=WORKDAY(C3,B3)
3.25 5/1/08 12:00 AM 5/4/08 6:00 AM 5/6/08 12:00 AM