Hi!

You can put a checkbox "in" cell B9 and link the checkbox to the same cell.
Set the font color to be the same as the fill color because when checked or
unchecked, B9 will return either TRUE or FALSE.

Now, add this to the current formula in B10:

+8*B9

Biff

"Chink!" wrote in message
...
Hello

I am making a timesheet to record working hours

Would it be possible to use a tick box ( I know how to add this to a cell)
to return a particular value in another cell?
I would like a user to be able to tick a box to indicate annual leave
lets say in cell B9
and by doing so return a value of 8 hours worked that day in cell B10.
Not ticking the box returns value of zero, or rather adds zero to B10
(B10 currently has the formula to total the hours worked for that day)

many thanks

CH!