Creating a forumula to pick up values in other cells...

Hi,

First post here, and I am hoping someone may be able to help me.

I am creating a worksheet to help me cost out the value and hours worked of various different people and items of equipment. This is in itself is easy enough to do.


However...


I have several different costing codes that I need to apply values to. I have many different people and items of equipment working every day, that are not applicable to each cost code.

What I need is to create a formula that will allow me to pick up all the hours relevant to a cost code (all on one row of a spreadsheet), then caluclate these hours with the hourly rate of the man/equipment.

Can anyone help?

Dear Mr/Mrs
I am also looking for solution of picking up the date (Not Month/ Nor Year) of a mentioned date. For example, only 14 out of 14-Feb-15. To do so, if a cell is met with one condition, then pick up that 14 only and paste the number into a specific cells.
Why I want it is that in my office, I want to check whether the staff are late office time or not. If someone was late, then I enter data for him as "Personal Late" (pl) or "On Duty Late" (odl). If either of those two words (pl and odl) appeared in a cell, then I want to pick up the date (e.g 14 from the date mentioned in another cell) and paste it in a cell in separate sheet. If that staff late again in another day, says 16-Feb-15, then again copy 16 and add into the same cell of 14 with comma.
By doing so, I can see the dates of a month that someone is late office within one cell.
Please help me.
[email protected]
If you need example excel book, I can send you.