If/ then question
 

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!

If/ then question
 

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
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If/ then question
 

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
-----Original Message-----
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
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.

If/ then question
 

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

-----Original Message-----
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
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.