Calculate comptime with automatic expiration

[Guest]

Hello and thanks for the help. I am using Excel 2000. I need to create a time sheet. There will be 28 pay periods which will be created on 28 different sheet tabs. Everything on each sheet is the same with this exception

Comp time expires every 14 pay periods. I am calculating comptime and keeping a running balance of what people have. Comp time earned in period 1 expires in period 14; earned in period 2 expires in period 15; earned in period 3 expires in period 16..

I can't figure out how to make the expiration happen automatically. On the period 14 worksheet I need the comptime earned from the period 1 sheet tab to expire (assuming there is any), therefore be subtracted from the running balance. That would continue through all 28 sheets

Ideas???

 

[Frank Kabel]

Hi
you may provide some more detail about the layout of your spreadsheet.
e.g. post some exampel data rows (plain text - no attachment pleaseI
and describe your expected result based on this

--
Regards
Frank Kabel
Frankfurt, Germany

Hello and thanks for the help. I am using Excel 2000. I need to

create a time sheet. There will be 28 pay periods which will be created
on 28 different sheet tabs. Everything on each sheet is the same with
this exception.

Comp time expires every 14 pay periods. I am calculating comptime and

keeping a running balance of what people have. Comp time earned in
period 1 expires in period 14; earned in period 2 expires in period 15;
earned in period 3 expires in period 16...

I can't figure out how to make the expiration happen automatically.

On the period 14 worksheet I need the comptime earned from the period 1
sheet tab to expire (assuming there is any), therefore be subtracted
from the running balance. That would continue through all 28 sheets.

 

[Anders S]

Hi Sheri,

In addition to Frank's answer,

If two conditions are met, Frank will fix this for you in no time at all <g>:

1. all sheets are consistently named, like Period01, Period02 ... Period11,
Period12 ... (note the zero in the first names)
2. the comptime values are in the same cells on all sheets

Best regards,
Anders Silven