Calculation of words into numbers

  • Thread starter Thread starter PeterBWhalley
  • Start date Start date
P

PeterBWhalley

I have time sheets laid out in a simple worksheet with days of the week
laid out, in 15 min intervals, with codes alongside the time.
(Different columns, naturally) For example, Work is W, Planning and
Strategy is STR, Social time is SOC, Reading is R and so on.

Example is attached.

I have been told PIVOT tables would work in estimating my goal of
seeing where I spend my time. This is a social experiment. However, in
the book I purchased, it is still not clear. Any pointing in the right
direction would be greatly apprecited.


+-------------------------------------------------------------------+
|Filename: Example for Forum.doc |
|Download: http://www.excelforum.com/attachment.php?postid=2693 |
+-------------------------------------------------------------------+
 
You could use a pivot table, with Code in the Row area, and Count of
Code in the data area. Each count would represent 15 minutes.

Or on the worksheet, use the COUNTIF function to calculate the
occurrences of each code, then multiply the result by 15 for total
minutes. For example: =COUNTIF(B:B,"W")*15

If you enter the codes in a list, you can refer to those in the formula.
For example, with a W in cell D2: =COUNTIF(B:B,D2)*15
 
Back
Top