T
TLAngelo
I have created a spreadsheet that calculates process times. If a product is
held overnight, then excel subtracts 14 hours from the total to account for
14 hours that are non-working hours, if a product is held over a weekend,
then excel subtracts 62 hours of non-working time (24x2 for Sat. & Sun. +14
for Fri. night). The problem I am running into is that if a product is held
for 1 or 2 days and those days are NOT weekends, then I only want it to
subtract the 14 hours for however many days.
Also, can you have separate formulas in a cell without nesting them? For
example, an "OR" formula?
held overnight, then excel subtracts 14 hours from the total to account for
14 hours that are non-working hours, if a product is held over a weekend,
then excel subtracts 62 hours of non-working time (24x2 for Sat. & Sun. +14
for Fri. night). The problem I am running into is that if a product is held
for 1 or 2 days and those days are NOT weekends, then I only want it to
subtract the 14 hours for however many days.
Also, can you have separate formulas in a cell without nesting them? For
example, an "OR" formula?