want to create a time card to add time

[Guest]

I'm trying to create a time card to add total of hours worked including
overtime, but i don't know how to do it. I had downloaded a different one
from the net but they don't help at all, please help.
M.

 

[Gord Dibben]

From where did you download one from the 'net and who are "they" that don't
help?

There are several at the MS Template Gallery

http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=timecards

Chip Pearson has some good info on timesheets including regular and overtime
reporting.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben MS Excel MVP

 

[David McRitchie]

Timesheets has come up in newsgroups quite often, so you
could find something, by
1) Use Google for a web search
2) Use Google for a groups search

If you did a Google search you would find Microsoft Templates.
You might run across a sample time sheet. Knowing that there is such
a place you use the following as your Google search
site:microsoft.com time-sheet excel
One of the Google hits is:
http://office.microsoft.com/en-us/assistance/ha011133131033.aspx

The timesheet templates should include calculations,
but some of the templates do not, in any case
you should learn about subtracting dates and times
anyway, see
http://www.cpearson.com/excel/datetime.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm

You might find an example of a time sheet
Employee Time Sheet
http://j-walk.com/ss/excel/files/timesht.htm

Please use your first and last name in newsgroups, at least
in technical newsgroups where people have to take some time
to answer questions. It would also help you to find your old
postings so you don't have to ask the same question again..