time sheet

J

JGB

Hi,

We are trying to use excel to track our hourly employee's time, we want them
to access it and use it to enter their time. Does anyone know a function
that would work so when they click on the box it will display the correct
time?

Thanks in advance,
 
V

vezerid

JGB said:
Hi,

We are trying to use excel to track our hourly employee's time, we want
them
to access it and use it to enter their time. Does anyone know a
function
that would work so when they click on the box it will display the
correct
time?

Thanks in advance,
Click to expand...
There exists function NOW(). When first entered in a cell

=NOW()

will display the current workstation system time. Every time there is a
recalculation it will be updated to show the current time. Same when
opening the workbook.

To simply enter the current date/time entry you could use key
combination Ctrl+; (semicolon) for time and Ctrl+: (colon, i.e. with
the key sequence Shift+Ctrl+; <semicolon>).

To further protect each cell from only being entered once you need more
sophisticated VBA event macros.

HTH
Kostis Vezerides
 
V

vezerid

JGB said:
Hi,

We are trying to use excel to track our hourly employee's time, we want
them
to access it and use it to enter their time. Does anyone know a
function
that would work so when they click on the box it will display the
correct
time?

Thanks in advance,
Click to expand...
There exists function NOW(). When first entered in a cell

=NOW()

will display the current workstation system time. Every time there is a
recalculation it will be updated to show the current time. Same when
opening the workbook.

To simply enter the current date/time entry you could use key
combination Ctrl+; (semicolon) for time and Ctrl+: (colon, i.e. with
the key sequence Shift+Ctrl+; <semicolon>).

To further protect each cell from only being entered once you need more
sophisticated VBA event macros.

HTH
Kostis Vezerides
 
J

JGB

Hi,
thank you for your response, the first link you provided is not working, can
you tell me it again or how to do a timestamp upon a double click. We are
wanting the employee to click on the cell and then it will display there
"clock-in" or "clock-out" times.

Thank you so much.

David McRitchie said:
To enter the time in Column A on first entry in any other column
http://www.mvps.org/dmcritchie/excel/enter.htm#timestamp
or you could enter a timestamp (date and time) into a cell upon doubleclick.
but I did not answer this before because I expect people cannot
type into Excel when they start and when they finish.
Click to expand...
 
Top