Excel program to do custom calculations
Budget: $250 – $750 USD
Hello everyone,
We are a small company and have employees that go out to clients to fix things. They log the jobs they performed in the Excel file. Each time they come to a client they log the date, time in and time out.
If they worked more than 8 hours per day or more than 40 hours per week we have to pay them extra for overtime.
I have Excel file that (among others) has columns:
1. Date
2. Client name
3. Employee name
4. Time in
5. Time out
I need a program that I can load this Excel file into and receive report that will tell me:
1. How many jobs each employee performed each day
2. How many hours each employee worked each day AND how long each job took to perform
I need 2 reports:
a. How many hours passed from start time of the first client of the day until the end time of the last client that day
b. Just a commutative hours: job 1 - 2 hours + job 2 1 hour + job 3 -1 hour = 4 hours total.
3. How many hours each employee worked for a week ( I need to be able to specify the date range for the report).
Thank you all very much.
We are a small company and have employees that go out to clients to fix things. They log the jobs they performed in the Excel file. Each time they come to a client they log the date, time in and time out.
If they worked more than 8 hours per day or more than 40 hours per week we have to pay them extra for overtime.
I have Excel file that (among others) has columns:
1. Date
2. Client name
3. Employee name
4. Time in
5. Time out
I need a program that I can load this Excel file into and receive report that will tell me:
1. How many jobs each employee performed each day
2. How many hours each employee worked each day AND how long each job took to perform
I need 2 reports:
a. How many hours passed from start time of the first client of the day until the end time of the last client that day
b. Just a commutative hours: job 1 - 2 hours + job 2 1 hour + job 3 -1 hour = 4 hours total.
3. How many hours each employee worked for a week ( I need to be able to specify the date range for the report).
Thank you all very much.