If Then Statements....

  • Thread starter Thread starter John Michael
  • Start date Start date
J

John Michael

Does Excel do If Then Statements?

What I would like to do is, if an employee worked a straight eleve
hours, pay him for an hour of lunch in another cell, and...

if an employee worked more than eleven hours, start counting from th
11th hour on until he finishes and get that number in a differen
cell...

Any possibilities?

Thanks in advance for all your help!

Providenc
 
Hi
have a look at the IF function. e.g.
IF(A1>TIME(11,0,0),rate*(A1*24+1),rate*(A1*24))

if A1 stores the working time as Time value
 
Frank:

Thanks for the quick response. I'm new to Excel, coming from FileMake
Pro.

Can you please explain the syntax for TIME(11,0,0). I understand the 1
is beginning with the 11th hour....

Also, the rate syntax. I understand Excel works on a 24 hour clock.

Kind regards,

Providenc
 
Back
Top