Calculate comptime with automatic expiration

S

Sheri

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???
 
F

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

Sheri said:
Hello and thanks for the help. I am using Excel 2000. I need to
Click to expand...
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
Click to expand...
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.
Click to expand...
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.
 
A

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
 
Top