Create a fast and easy to use, Excel-based weekly work timesheet for workflow and project time tracking in our small PR/media/marketing business.
We want to include a graphic front end interface incorporating our company branding/feel for staff to be presented with, with access to the backend data only for management. We can provide a full graphics/design if required.
The timesheet needs to have drop down selection menus listing our clients and their various departments, allocate job numbers (abbreviated client name/yy-mm-dd/job number of the day), include selection menu for job particulars (our departments/services), a space for staff comments undertaking the role, time started, finished and accumulated time spent.
We also need the capability of expanding the selection criteria at any stage, and to be able to draw information and statistics from the data input.
The goal of this project is to build a capability which will allow us to accurately track time spent on jobs, understand our workflow, organise job schedules, delegate responsibilities and build a database of knowledge from which we can build our business.
Date – (drop down menu, date selection)
Clients (list client names
Job Number – automatically allocated using abbreviated client name, date (yy-mm-dd) and job number of the day
Project – Project name
Job Type – (drop down menu listing our
Comments – room for employees to make comments on jobs
Time Started – (drop down menu, clock selection)
Time Finished – (drop down menu, clock selection)
Total Time – accumulated total from start/finish columns
We envisage this as the first of many jobs that we will undertake over coming weeks and months.
68 freelancers are bidding on average $11/hour for this job
Consider it done. Check my past reviews for your reference. I have create many such sheets before and I am sure will create user friendly interface for you. Eagerly looking forward for your reply.
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me Thank you, Farzana Pinky.
Hi there, I have created same type of time sheets in past project. I m ready to finish this task withing time and with full satisfaction. If interested pls reply asap....... thanks & regards: Mandeep Singh
Hey veracitymedia, If you are using WINDOWS based system, then we may the right team to approach... please have a look at our profile...we have delivered a lot of such products... thank you.. please reply !
Lovely project and nice job. I worked as a consultant and I am familiar with the time sheets and their role.I am also an experienced specialist in excel and I am interested for a long cooperation. Regards Doina