Time check
Good Afternoon!
I recently made a spreadsheet in Excel 2010 for employees to enter data on an hourly basis. Does Excel have a time stamp or is there a way that I can monitor the entries to be sure the data is entered hourly?
Thanks for any help you can give me!
Last edited by Ecel12; 05-03-2012 at 11:24 AM.
You can make it a shared workbook with track changes. Then when you go into track changes, uncheck Who and when. I usually check "list changes on separate sheet" You will get a list of all entries and when they were made.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks so much for you help. Unfortunately, my employees won't be thanking you. It is imperative that certain tests be run and documented hourly. This proved that the task was not being performed. I hate it when individuals put me into these kinds of situations!
Thanks again for your help. I love this forum and all the help I've gotten from it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks