formula help

S

scottasanchez

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
 
G

Guest

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

"(e-mail address removed)" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula 2
Adding Time in Excel - Frustating experience!! 5
how do i calculate a work schedule in excel? 3
directing the sum of a cell to either of two cells depending on va 3
deduct 30 minutes from a shift calculation in hours 1
IF,AND and OR 2
Problem with time formula 1
formula for hours on time sheet 4

Top