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
 
M

Marcelo

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

IF,AND and OR 2
Excel formula 2
Problem with time formula 1
directing the sum of a cell to either of two cells depending on va 3
EXCELL FORMULA 1
How do I get total amount of hours in time format 3
Adding Time in Excel - Frustating experience!! 5
Converting minutes to tenths 2

Top