My company has asked me to come up with a time sheet in Excel (using Excel
2002) that will allow the employee to digitally sign it before being sent to
HR.
The employee may work on 2 or 3 projects a day and currently fills out a
biweekly timesheet that shows the time spent on each project day by day.

I am not a programmer so I'm looking for advice and templates that I
can use to come up with this.

Your help is most appreciated.

Timcin,

Excel doesn't have any built-in electronic signature capability - except for signing VBA code
projects. But an easy way would be to have each employee save their timesheets in a folder than
only they can access, using your network's login capabilities. Then an administrator can access the
data from the files that are saved in those folders, to pay/summarize/etc. There are all sorts of
timesheet templates out the MS.com is a good starting point:

http://office.microsoft.com/en-us/te...172771033.aspx

HTH,
Bernie
MS Excel MVP


"Timcin" wrote in message
...
My company has asked me to come up with a time sheet in Excel (using Excel
2002) that will allow the employee to digitally sign it before being sent to
HR.
The employee may work on 2 or 3 projects a day and currently fills out a
biweekly timesheet that shows the time spent on each project day by day.

I am not a programmer so I'm looking for advice and templates that I
can use to come up with this.

Your help is most appreciated.

If this is possible for your situation, you could use a two-person
verification process to process the timesheets.

We use an in-house developed, on-line time reporting process as part of our
CMMI process. It could possibly be applied to your situation, if your
organization structure permits it.

Basically the employee submits their timesheet to their supervisor at the
end of a pay period. The supervisor reviews it and 'approves' it and it is
the supervisor that forwards all approved timesheets to accounting (HR in
your case) for processing.

In our process, because the timesheets are each accessible only through the
employee section of our web site, and because each employee is granted access
to that section by logging in with a username/password, it is accepted that
the login provides the 'electronic signature'.

You could emulate this process by using email to move the Excel timesheets
through the process pipeline, whether you use the supervisor as an
intermediate stopping point or not. By sending the Excel file as an
attachment to an email, you get verification that it came from a particular
individual by way of the return email address.

Your time keeping seems to be set up quite a bit like ours is: many projects
that one person can work on in a given day, bi-weekly time accounting, and
such. I'll grab one of our old 'manual' Excel versions of our timesheets and
'clean it up' to remove company specifics and put a link to it in a post I'll
add to this discussion later, perhaps it will give you some ideas, if not a
usable solution.

"Timcin" wrote:

My company has asked me to come up with a time sheet in Excel (using Excel
2002) that will allow the employee to digitally sign it before being sent to
HR.
The employee may work on 2 or 3 projects a day and currently fills out a
biweekly timesheet that shows the time spent on each project day by day.

I am not a programmer so I'm looking for advice and templates that I
can use to come up with this.

Your help is most appreciated.

Here's a link to a 'generic' bi-weekly time sheet that may help you get
started.
http://www.jlathamsite.com/uploads/B..._Timesheet.xls

"JLatham" wrote:

If this is possible for your situation, you could use a two-person
verification process to process the timesheets.

We use an in-house developed, on-line time reporting process as part of our
CMMI process. It could possibly be applied to your situation, if your
organization structure permits it.

Basically the employee submits their timesheet to their supervisor at the
end of a pay period. The supervisor reviews it and 'approves' it and it is
the supervisor that forwards all approved timesheets to accounting (HR in
your case) for processing.

In our process, because the timesheets are each accessible only through the
employee section of our web site, and because each employee is granted access
to that section by logging in with a username/password, it is accepted that
the login provides the 'electronic signature'.

You could emulate this process by using email to move the Excel timesheets
through the process pipeline, whether you use the supervisor as an
intermediate stopping point or not. By sending the Excel file as an
attachment to an email, you get verification that it came from a particular
individual by way of the return email address.

Your time keeping seems to be set up quite a bit like ours is: many projects
that one person can work on in a given day, bi-weekly time accounting, and
such. I'll grab one of our old 'manual' Excel versions of our timesheets and
'clean it up' to remove company specifics and put a link to it in a post I'll
add to this discussion later, perhaps it will give you some ideas, if not a
usable solution.

"Timcin" wrote:

My company has asked me to come up with a time sheet in Excel (using Excel
2002) that will allow the employee to digitally sign it before being sent to
HR.
The employee may work on 2 or 3 projects a day and currently fills out a
biweekly timesheet that shows the time spent on each project day by day.

I am not a programmer so I'm looking for advice and templates that I
can use to come up with this.

Your help is most appreciated.