Thread: formula for work rosters to deduct for different breaks
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default formula for work rosters to deduct for different breaks
=A1-LOOKUP(A1,{0,6,8},{0,0.5,1})


"vefl" wrote:

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
Reply With QuoteReply With Quote