May 29 2022 05:35 PM
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?
May 29 2022 09:47 PM - edited May 29 2022 09:48 PM
@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.