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