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,

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

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

To enter the time in Column A on first entry in any other column
http://www.mvps.org/dmcritchie/excel....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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vezerid" wrote in message
...

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

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" wrote:

To enter the time in Column A on first entry in any other column
http://www.mvps.org/dmcritchie/excel....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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vezerid" wrote in message
...

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

corrected link -- sorry about that
http://www.mvps.org/dmcritchie/excel....htm#timestamp