software

I am trying to track the last 30 days people worked overtime. I want to set
up my spreadsheet with the columns as the last 30 days and the rolls as
individual employees. If a person works today I enter the number of hours
worked under todays date column. Thrity days from now I will delete the
column form today. This is where I need help. When I drop (or delete) the
column that is 30 days old, I need to have the new column come on to the
spredsheet with the new (todays) date. I need to see the last 30 days of
information and to be able to pull that information like the number of days
worked and the number of hours worked.

PS. I am a beginner in excel so please keep replies simple to understand.


To keep things easy and simple, set up your spreadsheet as follows:

Leave column B Blank
Enter dates starting with the current date in row 1 columns C through
AF
Leave Column AG Blank
Enter formulas for total hours worked in Column AH:
e.g. =sum(B1:AG1)

Enter formulas for total days worked in column AI:

e.g. =COUNTIF(B2:AG2,quot;gt;0quot;) This will return the count of all days
worked.

To update the spreadsheet:

Insert a column before column AG and enter today's date in cell AG1
Delete Column CWilliam in Denver Wrote:
gt; I am trying to track the last 30 days people worked overtime. I want to
gt; set
gt; up my spreadsheet with the columns as the last 30 days and the rolls
gt; as
gt; individual employees. If a person works today I enter the number of
gt; hours
gt; worked under todays date column. Thrity days from now I will delete
gt; the
gt; column form today. This is where I need help. When I drop (or delete)
gt; the
gt; column that is 30 days old, I need to have the new column come on to
gt; the
gt; spredsheet with the new (todays) date. I need to see the last 30 days
gt; of
gt; information and to be able to pull that information like the number of
gt; days
gt; worked and the number of hours worked.
gt;
gt; PS. I am a beginner in excel so please keep replies simple to
gt; understand.--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=526632