Formula request (Excel 97 & 2000)

Topic

New Reply

Hello. I am hoping to use excel for an attendance register at work and count up everyone’s hours/shift etc. I am looking for a formula that will recognise what sort of shift someone has worked. In say cells C2:C9 I have the type of shift for each day of that week , D for day shift, N for night shift, AL for leave etc etc. and in D2:D9 I have the hours worked for that shift pattern. I then have the same in F2:F9 for the following week. A month per worksheet.
Below all this I hopefully would like a formula that would be able to search/lookup each weekly column to give the total hours associated to each shift type. D shift 27 hours, AL 8.5 hours, Admin 8 hours etc.
Hope I explained thinks OK if not I can supply more info, hopefully.
Cheers

Reply | Quote

Replies

(Edited by sdckapr on 26-Feb-05 06:51. Changed post with code to the updated version)

I think your question is very similar to post 380774 and you might be able to adapt the solutions found in that thread. The most pertinent is probably the function in post 380915 which could be modified to your specific needs.

Steve

Reply | Quote

I tried to modify from related post but got more confused. I think I am missing something simple, Will the IF function best fit my problem do you think?
AJM

Reply | Quote

AJM,

How bout something like this…

Brent

Reply | Quote

Brent
Thanks a lot, that exactly what I was looking for. I can adapt that now. It was the SUMIF function I required.
Thanks for doing this
Andrew

Reply | Quote

Andrew,

Never a problem. This is a great place. Someone will come up with an answer or two for most any question. Usually it is a race to get your reply in before someone else beats you to it. When I have a question or need advice for a problem I am working on, this is the first place I look to.

Brent

Reply | Quote