TomGilgenbach
New Member
- Joined
- Jun 4, 2016
- Messages
- 1
Hello,
I have looked high and low here and on the Internet for a template that will give me nearly what I need. I do not know how to use excel but I am teachable. I am using Excel 2010. Yes, I know that I am basically asking someone do do this work for me. If you don't want to help me, please don't leave a snarky answer that basically calls me lazy - unless it is very humorous. I don't feel bad for asking for this template because what I am doing here must have been done thousands of times at schools, daycare institutions, etc. Here is what I have and what I need:
1. I have approx. 50 student ID cards (each with their own barcode)
2. I have a barcode scanner
3. Obviously I have a computer (with Excel 2010)
When I first (when school starts) scan the student ID, I would like excel to:
1. Record the student's name
2. Record the time and day the student was scanned in
3. Record that information for a specific date
When I next (when school is over) scan the student ID, I would like excel to:
1. Add the time and day the student left school
2. Add that information to the same row as the original scan
It would look like this:
Monday, June 6, 2016
Student Name>Time scanned in > Time scanned out
Student Name>Time scanned in > Time scanned out
etc.
Tuesday, June 7, 2016
Student Name>Time scanned in > Time scanned out
Student Name>Time scanned in > Time scanned out
etc.
Thank you.
I have looked high and low here and on the Internet for a template that will give me nearly what I need. I do not know how to use excel but I am teachable. I am using Excel 2010. Yes, I know that I am basically asking someone do do this work for me. If you don't want to help me, please don't leave a snarky answer that basically calls me lazy - unless it is very humorous. I don't feel bad for asking for this template because what I am doing here must have been done thousands of times at schools, daycare institutions, etc. Here is what I have and what I need:
1. I have approx. 50 student ID cards (each with their own barcode)
2. I have a barcode scanner
3. Obviously I have a computer (with Excel 2010)
When I first (when school starts) scan the student ID, I would like excel to:
1. Record the student's name
2. Record the time and day the student was scanned in
3. Record that information for a specific date
When I next (when school is over) scan the student ID, I would like excel to:
1. Add the time and day the student left school
2. Add that information to the same row as the original scan
It would look like this:
Monday, June 6, 2016
Student Name>Time scanned in > Time scanned out
Student Name>Time scanned in > Time scanned out
etc.
Tuesday, June 7, 2016
Student Name>Time scanned in > Time scanned out
Student Name>Time scanned in > Time scanned out
etc.
Thank you.
