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