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.