Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default want to create a time card to add time

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default want to create a time card to add time

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 903
Default want to create a time card to add time

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WHO DO I CREATE A STATICT TIME FORMULA IN EXCEL? Carlos Excel Worksheet Functions 2 June 21st 06 12:55 PM
formula to determine time range overlap? William DeLeo Excel Discussion (Misc queries) 0 June 6th 06 08:26 PM
How do I create a time card with excel? wackywolves Excel Discussion (Misc queries) 2 April 29th 06 10:02 PM
Time Card OSSIE Excel Discussion (Misc queries) 1 March 17th 06 10:02 PM
How to create command button to save the dates and time Ken Vo Excel Discussion (Misc queries) 6 January 5th 06 04:18 AM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"