Man hours & working out hours worked for a specific employee

edited 12/09/19 in Smartsheet Basics

Hey everyone,

I'm new to this. Here's my sheet for reference.

Two things.

1. I want to have a man hours column that works out how many people are in the assigned to column (I've used people's initials) and multiplies that by the duration column i.e. if there are 3 people working on 07/06, i want to multiply that by 1d (duration column) to equal 24 man hours.

2. I want to work out how many days the casual workers have worked. Their initials are CF and OB. How's best to do that? So how to run a count function in the 'assigned to' column.

Thank you!