Help with Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
My apologies

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