Probably a really easy one guys. Want to create a resource plan for myself. Each day is split up into a morning session and afternoon session with each session being 3 hours long.
On my spreadsheet was looking at entering companies names with in the morning session or afternoon session throughout the week. At the end I would have a formual looking up each company and adding together all the hours. For example Company A, had five sessions during the week, so a lookup or IF statement would look for the name Company A and multiple the number of times it found it by 3. E.g. 5 x 3 = 15 hrs that week. Any thoughts?
<tbody>
</tbody>
On my spreadsheet was looking at entering companies names with in the morning session or afternoon session throughout the week. At the end I would have a formual looking up each company and adding together all the hours. For example Company A, had five sessions during the week, so a lookup or IF statement would look for the name Company A and multiple the number of times it found it by 3. E.g. 5 x 3 = 15 hrs that week. Any thoughts?
Monday | Tuesday | Wednesday | Thursday | |
Morning (3hrs) | Comp A | Comp B | Comp B | Comp B |
Afternoon (3hrs) | Comp A | Comp A | Comp B | Comp B |
<tbody>
</tbody>