Help with Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jezzer - 12 Mar 2007 10:35 GMT

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

Reply to this Message

Roger Govier - 12 Mar 2007 12:25 GMT

Hi

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

change ranges to suit

Signature

Regards

Roger Govier

> Im new to Excel and need o do a work place shift roster. I need to put
> in the
[quoted text clipped - 4 lines]
> at the end of each week i can sum the total hours each member of staff
> does... can anybody tell me how please

Reply to this Message

Roger Govier - 12 Mar 2007 12:44 GMT

My apologies

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

Signature

Regards

Roger Govier

> Hi
>
[quoted text clipped - 13 lines]
>> staff
>> does... can anybody tell me how please

Reply to this Message

Sandy Mann - 12 Mar 2007 12:35 GMT

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)

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Im new to Excel and need o do a work place shift roster. I need to put in
> the
[quoted text clipped - 4 lines]
> at the end of each week i can sum the total hours each member of staff
> does... can anybody tell me how please

Reply to this Message