Mick,

You can use the function COUNTIF.

For example, if you have your daily entries in row 3, and you're using columns B through H for days of the week, you could use this formula in cell I3: =0*COUNTIF(B3:H3,"RD")+13*COUNTIF(B3:H3,"A")+...

I think you get the picture.

Good Luck,


Mike

--- On Wed, 6/4/08, Mick Fitzpatrick <[log in to unmask]> wrote:

> From: Mick Fitzpatrick <[log in to unmask]>
> Subject: [PCSOFT] Excel letters and numbers to represent numbers?
> To: [log in to unmask]
> Date: Wednesday, June 4, 2008, 4:09 AM
> Hello
> 
> I am putting my work shift pattern into an Excel
> spreadsheet.
> 
> The shifts are represented like so:
> 
> RD = 0 (because its a rest day)
> A = 13 hours
> M1 = 8 hours
> E = 5 hours
> E2 = 6 hours
> etc etc
> 
> What I am trying to do is make make excel is leave A, M1 or
> E etc in the 
> cell but recognise it as a figure then do a simple
> calculation/addition at 
> the end of each week to show me how many hours I have
> worked.
> 
> I hope I have explained myself OK and any advise/help will
> be appreciated.
> 
> Many thanks ... Mick 
> 
> 
> 
> 
> 
> E-mail message checked by Spyware Doctor (5.5.0.212)
> Database version: 5.09780e
> http://www.pctools.com/uk/spyware-doctor/
> 
>              Do you want to signoff PCSOFT or just change
> to
>                     Digest mode - visit our web site:
>                    http://freepctech.com/pcsoft.shtml


      

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml