I have an Excel spreadsheet (attached) that calculates time by employee over a two week period based on start/ time stop time.
I need this spreadsheet to be modified to add/include the following columns for each day:
Day of Week/ Date Worked / Doctor/ County/ Mileage Roundtrip/ Rate per Mile/
(contined columns across same line as above )
Total Mileage Pay/ Tolls/ Parking / Other Expenses / Per Diem
Further detail on columns:
The second set of start/stop times is designed for a break. There would be no breaks on this spreadsheet so I would need these 2 columns eliminated
Doctor ( Name of client would be filled in)
County ( Drop down of 7-8 County Names to choose from )
Per Diem ( I would neet a master table to include 5 -6 Counties, and a per diem rate for each county that would auto-populate this column. For example if they chose Brooklyn on drop-down, and master table showed per diem of $15 for Brookly, $15 would auto-populate the per diem column) I would also need the flexibility to easily alter this master table for different employees)
Eliminate the colums for overtime, sick time, vacation.
This is a bi-weekly spreadsheet, so use the bi-weekly tab. I would need totals on all the above columns for each two week period. I would also need a daily total for each line across on the right
40 freelancers are bidding on average $67 for this job
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have already finish design and input formula in attachment, please see PM.
Hi, I can help design the timesheet document as per your requirements. I am happy to make any modifications upon further communication between us as well. Thanks
Well i am new but very much efficient in MS Excel. and i am confidnet that i could complete this project within 2 days. If i get the opportunity then i will prove it. Thanks, Abhishek.
Dear Sir I am ready to work your project. I understand your requirement. and I will finish your project honesylu in time when you want so give more information of this project