If/ then question

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

I have written a time sheet for our employees to keep
track of their time. The file keeps a running total of
annual leave. I've written three files, one for each
leave category, which is either 8, 6, or 4. The pertinent
formula looks like this: =X2-X3+TIME(8,0,0); =X2-X3+TIME
(6,0,0) or =X2-X3+TIME(4,0,0).

Is there an if/ then statement where the employees can
enter in another cell 8, 6, or 4 and the correct formula
would be used? That being possible, only one time sheet
would be needed. And if an employee would change leave
category, he could easily correct his leave tally.

Thank you for your help!
 
Sure! Let's say you have them put the category in cell Y2:

=X2-X3+TIME(Y2,0,0);

Let me know if that doesn't work or if I misunderstood.

Mark
 
Thanks, Mark! It worked like a champ! There's one item I
still need help with. On the last pay period (or the
last work sheet), those in the 6 hour category earn 10
hours, not 6. Is there a way to insert an if/then so that
if y2=6 ,the formula will be =x2-x3+ time(10,0,0)? All
other categories will still fit into the original formula.

Thanks for your help.

Ellen
 
Hello Mark,
In a reply note I wrote:
Thanks, Mark! It worked like a champ! There's one item I
still need help with. On the last pay period (or the
last work sheet), those in the 6 hour category earn 10
hours, not 6. Is there a way to insert an if/then so that
if y2=6 ,the formula will be =x2-x3+ time(10,0,0)? All
other categories will still fit into the original formula.

Well, I've answered my own question. This formula will
work for the final pay period, or last worksheet:

=X2-X3+TIME(IF(Y2=6,Y2+4,Y2),0,0)


Thanks, again.
Psalm 23

Ellen
 
Back
Top