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