A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Detailed Time Sheet (overtime, comp time, vacation used)



 
 
Thread Tools Display Modes
  #1  
Old May 22nd 06, 04:08 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Detailed Time Sheet (overtime, comp time, vacation used)

I need to track in time, out time, in time, out time, overtime, vacation
totals (received/used), comp received, comp used, and so.
Ads
  #2  
Old May 22nd 06, 04:24 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Detailed Time Sheet (overtime, comp time, vacation used)

I would recommend to write all the headers on row 1, and start entering the
data on row 2. Any column that is a calculation, enter a formula (for
example, if column E is the difference of column D and C, enter "=D2-C2") and
format the cells as you want the data to be presented (date/time, number,
etc.)

Hope this helps,
Miguel.

"Robert D. Sandersfeld" wrote:

> I need to track in time, out time, in time, out time, overtime, vacation
> totals (received/used), comp received, comp used, and so.

  #3  
Old May 22nd 06, 10:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Detailed Time Sheet (overtime, comp time, vacation used)

You should keep in mind that an Excel time is really a fraction
of a day. You can read more about Date and Time at
http://www.mvps.org/dmcritchie/excel/datetime.htm
and on a page by Chip Pearson at
http://www.cpearson.com/excel/datetime.htm
you will also find sample timesheet that you can download from one of
Chip's pages. And there is simple timesheet on John Walkenbach's pages
as well try a search on his page. http://www.j-walk/ss/excel
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Miguel Zapico" > wrote in message ...
> I would recommend to write all the headers on row 1, and start entering the
> data on row 2. Any column that is a calculation, enter a formula (for
> example, if column E is the difference of column D and C, enter "=D2-C2") and
> format the cells as you want the data to be presented (date/time, number,
> etc.)
>
> Hope this helps,
> Miguel.
>
> "Robert D. Sandersfeld" wrote:
>
> > I need to track in time, out time, in time, out time, overtime, vacation
> > totals (received/used), comp received, comp used, and so.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Sheet GettingaHeadache Excel Discussion (Misc queries) 8 March 29th 06 06:43 PM
time sheet Monty Excel Discussion (Misc queries) 1 March 24th 06 10:21 AM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 10:30 PM
Excel Used as a Time Sheet emanna Excel Discussion (Misc queries) 6 March 2nd 06 05:25 PM
time sheet Rusty Boy Excel Worksheet Functions 2 December 2nd 04 03:49 PM


All times are GMT +1. The time now is 05:16 AM.


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