Have just remebered that the computers at work are in English (as opposed to
my computer that is in Swedish), how would this formula be on English excel ??

"Peo Sjoblom" wrote:

Try this in Swedish

=PRODUKTSUMMA(ANTAL.OM(A1:A100;{"E";"E1"});{8;8,25 })



--
Regards,

Peo Sjoblom



"Richard in Stockholm" wrote
in message ...
Thanx - my swedish version of excel 2007 didn't like that but I'm trying
all
variations as we speak.

Richard

"FSt1" wrote:

hi,
you might try a helper column with an if formula...

=IF(B3="E",8.25,IF(B3="E1",8,0))

then sum the helper column. not sure how many codes you have but you can
nestle 7 codes in an if formula. the formula i supplied has 2.

Regards
FSt1


"Richard in Stockholm" wrote:

I do a lot of timetables where we use letters of the alphabet to
represent
different shifts for example E = 8.25 hrs work, E1 = 8 hours. I usually
do
all the timetables in excel. I was wondering how do I assign numerical
values
to each letter/code so that it adds up the total time in one cell? I
want the
letters to remain but for them to have numerical values and then have
one
cell that adds up all the hours worked as a number.

For example if one person works E, E, E, E on four different days (i.e.
8.25
hours on four different days/cells) how do I get excel to give E an
value of
8.25 so that the box that adds up the total values shows the total
(33)?

Is there a function where I can give values to specific letters in a
block
rather than putting in a formula in each cell (if there is one of
course) ?

This sounds rather complicated but would save me a lot of work. I would
be
sooooo grateful to anyone who could help me.