This is my first time using this website, so please forgive my inexperience with Excel and any daft questions I have.
I am trying to create a spreadsheet to manage employee time worked. It will record hours worked, plus any days (or
portions of days) taken for different types of leave.
My problem is that I don't know what type of formula in
C62 to use to say "if there's an 'S' in cell C8, then add value in D8; and If there's an 'S' in C9, then add value in
D9, and so on, so that I eventually get a total of all sick days that employee 1 has taken in the month, i.e. 2 .
Because there will always be the need to record, say, a half day worked and a half day's holiday, I have left 2 cells
available for each date, one to record W (hours worked) and one for all other variables.
If anyone knows what type
of formala I should be using to work this out, I would extremely grateful. I'm a bit of a novice when it comes to any
formulae past simple SUM etc!
I will be using a tab for each month, and link the totals into future months. Think
this should be easy enough to work out.