payroll Clocking in and out

[Supachad]

Hi, I would like to set up a spreadsheet that calculates the payroll for my
company, at the moment I can only do this by manually inputting the values
off the cards, I would like to set up a form so that staff just hit clock in
on their way in. Then as they leave they hit clock out, I have a spreadsheet
set up and understand how to do time calculations, macros, forms and most
formulas in excel, my problems is if I link to a cell with time I don't no
how to keep that time, as when the sheet is refreshed the clock’s time is
refreshed, and then clock in time is lost, how do I link to a cell, get the
value from it then not have that value change even when the rest of the page
is refreshed thanks for any help.

 

[Tom Ogilvy]

Instead of using a formula like =now(), you would hard code the value.

activecell.formula = "=now()"
activecell.Formula = activecell.value

or do it directly

ActiveCell.Value = Now

in the second case, this is the VBA function now which is equivalent to the
Worksheet formula, but here you are putting in a fixed value.