I'm pretty out of my depth here, so any help would be much appreciated.

I'm trying to set up an attendance form to cover a 24 hour perid. i'd like a
columnof 14 checkboxes (places available per hour), and at the bottom a total
of how many boxes have been checked, and then repeated for the following 23
columns.

How do i go about giving a cell the value of "1"if the box is checked, and
accumulated the total of checked boxes. I'm struggling to get past changing
"true"/"false" values to "1"/"0" values.

Also, do i have to do this 2352 seperate times (14 places x 24 hours x 7
days a week), or can i do copy and paste?