Create cell value if coloured in and then total number of coloured cells

Occasional Visitor

I am creating a roster in excel.  Every coloured cell is 10mins.  If the cells are coloured they are working.

At the bottom I want to add up all the calculated cells to give me a total of hours worked for that person.

How do I do this please?


1 Reply

@AmyMPreschool Counting and calculating with colors is not native to Excel and requires VBA programming. I would recommend you to enter the number 1 in each '10-minute' cell when worked and apply Conditional formatting to give the color you want.


Then you can sum the rows for each person, giving a total of let's say 24. That would be 24 x 10 min = 240 min. Divide by 60 and you'll end-up with 4 hours.


See attached.