time sheet
 

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,

time sheet
 

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

time sheet
 

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

time sheet
 

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

time sheet
 

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

time sheet
 

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