Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 22nd 06, 04:08 PM posted to microsoft.public.excel.newusers
Robert D. Sandersfeld
 
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.

  #2   Report Post  
Old May 22nd 06, 04:24 PM posted to microsoft.public.excel.newusers
Miguel Zapico
 
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   Report Post  
Old May 22nd 06, 10:14 PM posted to microsoft.public.excel.newusers
David McRitchie
 
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.





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
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 11:21 AM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 11:30 PM
Excel Used as a Time Sheet emanna Excel Discussion (Misc queries) 6 March 2nd 06 06:25 PM
time sheet Rusty Boy Excel Worksheet Functions 2 December 2nd 04 04:49 PM


All times are GMT +1. The time now is 11:19 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017