With time in cell A1 in excel time format; try the below formula and format
to time

=IF(A1=TIME(8,0,0),A1-TIME(0,60,0),IF(A1=TIME(6,0,0),A1-TIME(0,30,0),0))


If this post helps click Yes
---------------
Jacob Skaria


"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