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!