ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   entering times automaticly (https://www.excelbanter.com/excel-discussion-misc-queries/25129-entering-times-automaticly.html)

George

entering times automaticly
 
Just wondering if it is possible for employees to type a 4 digit # (like the
last four of a social) and exel will enter a time into a position.
We currently use time cards, and have to enter them all in by hand at the
end of the night.
Let me know if you have any ideas.


Hi
Have a look at this:
http://www.cpearson.com/excel/DateTimeEntry.htm
It may be of use to you!

--
Andy.


"George" wrote in message
...
Just wondering if it is possible for employees to type a 4 digit # (like
the
last four of a social) and exel will enter a time into a position.
We currently use time cards, and have to enter them all in by hand at the
end of the night.
Let me know if you have any ideas.




JE McGimpsey

Take a look he

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
George wrote:

Just wondering if it is possible for employees to type a 4 digit # (like the
last four of a social) and exel will enter a time into a position.
We currently use time cards, and have to enter them all in by hand at the
end of the night.
Let me know if you have any ideas.



All times are GMT +1. The time now is 09:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com