Calculation of words into numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PeterBWhalley - 05 Oct 2004 08:42 GMT

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 |

+-------------------------------------------------------------------+

Signature

PeterBWhalley

Reply to this Message

Debra Dalgleish - 05 Oct 2004 12:08 GMT

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

> 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.
[quoted text clipped - 12 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=2693 |
> +-------------------------------------------------------------------+

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message