j19_2002
07-23-2009, 12:13 PM
I need help finalizing this time sheet for my employees.
They do not have a set schedule so their time in/time out may differ on a day to day basis. Also not all employees are full time, some work 40, other 20 or even 15 hrs per week.
Note: I converted the time to be in increments of .25 for each 15 minutes.
1st Issue:
What I am trying to do is have a time schedule where each employee puts their log in and log out time (which is the part thats already done) and at the end it takes off 30 minutes or .50 from the hrs worked which is the 30 minute lunch they receive. But if nothing is placed in the log in/log out it doesn't take off the 30 minutes so the total hours worked value stays zero instead of being -.50
2nd Issue:
I Want to be able to place "PTO" into the log in or log out time to have it calculate the hours worked for that day without taking out the 30 minutes for lunch. I added a column so that it takes whatever value I put into that column for each name, it uses that value as hours worked for PTO.
I placed an example on the spreadsheet and have attached the actual timesheet I am trying to use.
I know its pretty long but hopefully someone can help me out
THANK YOU!!!!!!!!!!!
They do not have a set schedule so their time in/time out may differ on a day to day basis. Also not all employees are full time, some work 40, other 20 or even 15 hrs per week.
Note: I converted the time to be in increments of .25 for each 15 minutes.
1st Issue:
What I am trying to do is have a time schedule where each employee puts their log in and log out time (which is the part thats already done) and at the end it takes off 30 minutes or .50 from the hrs worked which is the 30 minute lunch they receive. But if nothing is placed in the log in/log out it doesn't take off the 30 minutes so the total hours worked value stays zero instead of being -.50
2nd Issue:
I Want to be able to place "PTO" into the log in or log out time to have it calculate the hours worked for that day without taking out the 30 minutes for lunch. I added a column so that it takes whatever value I put into that column for each name, it uses that value as hours worked for PTO.
I placed an example on the spreadsheet and have attached the actual timesheet I am trying to use.
I know its pretty long but hopefully someone can help me out
THANK YOU!!!!!!!!!!!