Creating a formula in Excel

D

Desperate Jae

How do I create a formula to update weekly PTO time? I have to keep up with
300 employees PTO time on a weekly basis. Example: I accumlate 1.54 hours at
the end of every week with the week ending every Sunday. So starting
1/10/2010 I started off with 1.54 hours. Now, on 2/28/2010 I have accumlated
12.32 hours. I have people constantly asking me how many hours do they have.
I would like to create a spreadsheet with all the employees names on it and
have it update every Sunday, so that I will not have to go to the calculator
for all these employees. Could someone give me an example formula?
 
P

pmartglass

Is there any additional requirements
like how much time they had at the beginning of the year, how much time they
have already taken, etc
to calculate what has been earned since the first of the year you could use
something like =(WEEKNUM(NOW())-2)*1.54
this would give you the number of full weeks eligable
because I am subtracting the current week and the first week
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top