Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default formula help

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