employee timesheet

[Aristotle]

We would like to use Project server to keep track of employee hours and
generate timesheets for our HR and billing to clients. There must be an easy
way to do this? The employees would each run their own sheets off the system
and submit the paper or electronic versions to HR. A standard time sheet
showing each day in the pay period (date range), the hours worked on each
project and totaling at the bottom and end.

The billing is a little easier as we will do this from Project directly I
hope.

Thanks

 

[Philip Lanier]

There are a couple options for you:

1) When a user views their timesheet in PWA, they can click the link
"Export Grid to Excel" in the lower right corner of the timesheet. You can
try it for yourself and see what happens. Note that only what is displayed
in the grid will be exported; that is, if information is hidden because some
nodes are collapsed, that info will not be displayed in the spreadsheet.
Unfortunately, there's no way to easily customize the spreadsheet view aside
from writing some some custom code within Excel (e.g. VBA) to reformat data
how you might like. But it doesn't do a bad job.

2) Write an application that leverages the PDS (Project Data Service) to
retrieve information from the PWA timesheets and sends it to accounting. We
actually do a lot of this type of work for our clients. There a number of
options you'd have here... it could be an automatic process that runs, say,
every friday; it could be run by each employee, directly from the PWA
interface; it could be run from within another server application such as
SharePoint by the each employee; it could generate a printable page that
they print out and take to HR; it could save the information to a file that
HR then prints out; it could be sent to a holding database; it could be send
directly into the hr system, if that was possible. As you can see, there
are a lot options with this route. It might take a little more work, but is
definitely a more flexible option. Note that with this route, you should
also be able to filter based on whether the time was approved or not.

I hope this helpful!

Philip Lanier,
Ascentium Corporation