PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?Um9iZXJ0IEQuIFNhbmRlcnNmZWxk?=
Guest
Posts: n/a
 
      22nd May 2006
I need to track in time, out time, in time, out time, overtime, vacation
totals (received/used), comp received, comp used, and so.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWlndWVsIFphcGljbw==?=
Guest
Posts: n/a
 
      22nd May 2006
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 With Quote
 
David McRitchie
Guest
Posts: n/a
 
      22nd May 2006
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" <(E-Mail Removed)> wrote in message news:4529ED82-8D30-4569-AAE2-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vacation Time + Sick Time + Overtime + Time Management JK Microsoft Access 1 5th Sep 2008 06:24 PM
Calculating Regular time, overtime and double time =?Utf-8?B?QnJpYW4gU21pdGg=?= Microsoft Excel Worksheet Functions 5 9th Nov 2007 10:32 PM
help with calculating overtime in a time sheet jongyrocka Microsoft Excel Misc 13 10th Dec 2005 09:36 PM
Re: template that tracks regular, vacation & comp time? djzabala Microsoft Excel New Users 0 3rd Sep 2004 10:59 PM
Time Sheet and Comp Time Chuck Duchon Microsoft Excel Programming 5 14th Sep 2003 06:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:36 AM.