Excell function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to total the numbers in a row of cells with different notations.
I am working on a timesheet where the daily credit hours, annual and sick
leave are noted, and totaled. I am doing this manually now, I would like to
do it excel.
Mon Tues Wed Thu Fri Annual total Credit Earned Credit Used
2cre 1cru 1cre 1a 1cre 1 4
1

Is it possible to put this in excel? I want the function to
recognize/distinguish between the 'cre', 'cru' and 'a' notations.
 
Put your days/dates down a column, not across a row
Then use a layout such as

Date Code Unit
4/1/2007 1cru 1
4/2/2007 1a 1
etc

Then you can use the power of Excel's Pivot Tables to generate all kinds of
valuable reports, grouping by date ranges (think weeks, months, years) if
needs be. I'm guessing you will also want a column for employee name, too,
so your Pivot Table can summarize by employee
 
Thanks for respondign Duke. I already have date columns. I need a total of
the cre or leave time used on each day of the week.
DATE SUN MON TUE EAR USE BAL
01/07-01/20 2cre 2cre 6 279.5
01/21-02/3 2cru 6 2 285.5
 
Thank you Duke for responding. I have a column for the dates already.
DATE MON TUE EAR USE BAL
01/07-01/2 2cre 2cre 2 0 279.5
01/21-02/ 1cre 1cru 1 1 285.5

I need to total the informatin in the columns.
 
No, you have a column that contains text that describes a range of dates.
You really need a single date in each cell - I'm using a mm/dd/yy format below

Date Code Employee
01/02/07 2cre Joe
01/02/07 1cre Betty
01/03/07 1cru Joe
01/03/07 1a Betty

You use this structure for your pivot table, putting the dates in the column
area. Doing that allows you to group the dates by different intervals
 
Back
Top