Check box formula question

[simon frost]

Hi All,

newbie here so be gentle

I have created a scheduling spreadsheet and i want to put in an option that if an employee doesnt take their 1 hour lunch break i would check the check box (returning a true value) and the formula would add an hour to the total hours for that day.

Im good with creating the check box etc but im stumped on the formula side.

Any thoughts ?

cheers

 

[Andrew Poulsom]

Welcome to MrExcel.

If you link your Checkbox to a cell you can use that cell in your calculation.

 

[simon frost]

cheers. Ok i found a way of doing it. Had to link every check box to a seperate cell then hide the linked cells. The only problem is that as my spreadsheet is very large (52 weeks of the year in tabs with 14 staff per tab, plus Quarterly summeries etc) my spread sheet now runs at slower than a snails pace. I have lots of COUNTIF formulas for counting annual leave , sick leave days.

Anyway of doing the check box thing as described above but with out check boxes ? maybe with a button or a toggle button?

cheers

 

[Andrew Poulsom]

I don't see how using a different control would make any difference.