In Progress

Excel Time and Expense Worksheet

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

Thank You

Skills: Excel

See more: time expense worksheet, time expense excel, excel employee per diem worksheet, spreadsheet doctor, excel 16, doctor spreadsheet, time worksheet excel, master excel, time table, neet, expense, excel table, excel 7, brooklyn, break times, counties excel, populate excel spreadsheet spreadsheet, excel modified, 2011 excel add, rate table excel, populate excel spreadsheet, time time employee, excel populate worksheet worksheet, excel drop, rate doctor

About the Employer:
( 1 review ) South Salem, United States

Project ID: #1250580

Awarded to:

rwijaya

Hi, please check PM. I am ready to finish it now. Thank you.

$35 USD in 0 days
(1 Review)
1.1

40 freelancers are bidding on average $67 for this job

vserv

Pls see your messages. Thanks

$50 USD in 2 days
(53 Reviews)
5.6
koolsidz

Excel Whiz at your service ;) Please see PMB for more details.

$111 USD in 1 day
(85 Reviews)
5.6
FIBIN

Hi I am interested to work for your project. I have experience working in lot of excel applications.I can deliver your the best in minimum time. Please see my PM for more details and attached samples for reference. More

$50 USD in 2 days
(38 Reviews)
5.1
dataconsultants

Please check PMB for details. Thank you

$135 USD in 4 days
(45 Reviews)
5.1
dev3dworx

Please check PMB for details.

$200 USD in 5 days
(19 Reviews)
4.7
psprongs

HI, I have a good deal of experience in data processing using excel. I can start immediately. Please check PMB psprongs

$45 USD in 2 days
(9 Reviews)
4.2
ExactSystems

Please see bid detail on PMB. regards

$95 USD in 4 days
(2 Reviews)
4.3
JJdatajobs

Hello 'MBN2011', I have done similar work. I am submitting my detailed bid in the PM. Kindly review. With regards, JJdatajobs.

$50 USD in 3 days
(13 Reviews)
4.0
Pichart

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.

$30 USD in 2 days
(13 Reviews)
3.8
muthumuni

Hi, Very much interested about this job. So kindly see my offer at PMB. Thank you.

$30 USD in 0 days
(6 Reviews)
3.5
manohartvs

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

$50 USD in 3 days
(3 Reviews)
2.7
SilviaT

Please check PM.

$50 USD in 7 days
(5 Reviews)
2.4
bharat1010

Have a good experience working in excel. Let me know when to start.

$80 USD in 1 day
(2 Reviews)
2.2
rief

Hi, I've been living with Excel for years. Let me take the do the project.

$50 USD in 4 days
(1 Review)
1.0
lex9

Hi, I can efficiently work with excel. I am willing to work on this project. Please let me try. Thanks.

$100 USD in 2 days
(0 Reviews)
0.0
luckyabhipri

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.

$30 USD in 2 days
(0 Reviews)
0.0
kiruthiga12

Hi, ready to start the work.

$40 USD in 5 days
(0 Reviews)
0.0
battleg5

I am interested on this project.

$30 USD in 3 days
(0 Reviews)
0.0
SERAJ1

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

$80 USD in 7 days
(0 Reviews)
0.0
mike1018

greetings from mike, i interested to do this project for you. i've attached a sample in my pm, please check my pm as well.

$40 USD in 1 day
(0 Reviews)
0.0