Specialized Spreadsheet

M

Michael

Anybody want to tackle a special request for a specialized spreadsheet
function? I need a way to track persons progress on a project. for example,
they have 2080 hours in a work year. I need to account for holidays and
weekends then if they are what ever project they can charge to. For example
if they have 500 hrs on one project, 300 on another etc, planned days off and
vacation it should project their time etc.

My office e-mail is (e-mail address removed)
 
J

joel

Do you use MS Project. You can write macros in MS project that wil
export the data into an excel worksheet. the do your tracking from
excel. Let project count the days and holidays which will simplifiy the
work in excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to select values after a certain date 0
SOS-Need to calculate number of working hours per each week of mon 2
Paste Special between Spreadsheets 2
Help with IF function 3
Another Days, Hours, Minutes, Question 6
Resource Pooling and client rates 3
MS Project - Multiple Projects in Master File 6
Macro to break one row of data into multiple rows, with calcuation 1

Top