I have a spreadsheet that calculates employees time on their projects. Column
A is their start time and column B is their stop time. The formula calculates
the time taken, but I have to manually deduct their breaks. With 9 shift
zones, how can I fit in a logical formula that recognizes that when a break
occurs between the start and stop time to deduct either the 15 minutes or 30
minutes if on lunch?
--
joe z