JGB Wrote:
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,
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


--
vezerid
------------------------------------------------------------------------
vezerid's Profile: http://www.excelforum.com/member.php...o&userid=28481
View this thread: http://www.excelforum.com/showthread...hreadid=505860