View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vefl vefl is offline
external usenet poster
 
Posts: 1
Default formula for work rosters to deduct for different breaks

From hours rostered on a spreadsheet I need to deduct 30 mins for a break if
staff workd 6 hours or more, and deduct 60 mins for a break if staff work 8
hours or more