Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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/re...uery=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 On Fri, 1 Sep 2006 19:56:01 -0700, how to create a time card to add time <how to create a time card to add wrote: 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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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/as...133131033.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.. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "how to create a time card to add time" wrote 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WHO DO I CREATE A STATICT TIME FORMULA IN EXCEL? | Excel Worksheet Functions | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
How do I create a time card with excel? | Excel Discussion (Misc queries) | |||
Time Card | Excel Discussion (Misc queries) | |||
How to create command button to save the dates and time | Excel Discussion (Misc queries) |