payroll Clocking in and out
 

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 clocks 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.

payroll Clocking in and out
 

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.

--
Regards,
Tom Ogilvy

"Supachad" wrote in message
...
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.