Help with Excel
 

Im new to Excel and need o do a work place shift roster. I need to put in the
shifts people work eg: E (early) L (lates) N for nights ... but i also need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need this so
at the end of each week i can sum the total hours each member of staff
does... can anybody tell me how please

Help with Excel
 

Hi

Try
=SUMIF(A1:A10,"E")*7.5
=SUMIF(A1:A10,"N")*12

change ranges to suit

--
Regards

Roger Govier


"Jezzer" wrote in message
...
Im new to Excel and need o do a work place shift roster. I need to put
in the
shifts people work eg: E (early) L (lates) N for nights ... but i also
need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need
this so
at the end of each week i can sum the total hours each member of staff
does... can anybody tell me how please

Help with Excel
 

Assuming that the shifts are in B2:H2 try something like:

=SUM(COUNTIF(B2:H2,"E")*7.5,COUNTIF(B2:H2,"L")*7.5 ,COUNTIF(B2:H2,"N")*12)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Jezzer" wrote in message
...
Im new to Excel and need o do a work place shift roster. I need to put in
the
shifts people work eg: E (early) L (lates) N for nights ... but i also
need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need this
so
at the end of each week i can sum the total hours each member of staff
does... can anybody tell me how please

Help with Excel
 

My apologies

Those should have been COUNTIF's not SUMIF's
=COUNTIF(A1:A10,"E")*7.5
=COUNTIF(A1:A10,"N")*12


--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

Try
=SUMIF(A1:A10,"E")*7.5
=SUMIF(A1:A10,"N")*12

change ranges to suit

--
Regards

Roger Govier


"Jezzer" wrote in message
...
Im new to Excel and need o do a work place shift roster. I need to
put in the
shifts people work eg: E (early) L (lates) N for nights ... but i
also need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need
this so
at the end of each week i can sum the total hours each member of
staff
does... can anybody tell me how please