Hi Scott,

I'm not sure i misunderstood something but I thik you can use it:

=if(e5=time(5,0,0),e5-0,0205,e5)

hth
regards from Brazil
Marcelo

" escreveu:

I am trying to modify a formula and I am looking for some assistance. I
am working on a time sheet where I need to create an if then formula
to deduct 30 minutes if the total hours equal 5 hours or more. The
current formula looks as follows: =V11-0.0205. This references a
subtotal column (V11 and subtracts 30 minutes).

Scott