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!
.