Help with Excel

[Guest]

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

 

[Roger Govier]

Hi

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

change ranges to suit

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Roger Govier]

My apologies

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