Greetings,
I am using a bar code scanner and student ID cards to track my students jogging lap times.
I am trying to create an Excel formula to record and organize their times but I cannot figure out how to set up it up where if I have already scanned one student, their ID number isn't scanned again, only the time stamp from the scan.
Also how do I have that information be tracked in rows and not in one giant column down.
Below is a picture of how I envisioned it looking.
In case that link isn't working
Something like this:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My knowledge of Excel is very limited and any help would be greatly appreciated.
I am using a bar code scanner and student ID cards to track my students jogging lap times.
I am trying to create an Excel formula to record and organize their times but I cannot figure out how to set up it up where if I have already scanned one student, their ID number isn't scanned again, only the time stamp from the scan.
Also how do I have that information be tracked in rows and not in one giant column down.
Below is a picture of how I envisioned it looking.
In case that link isn't working
Something like this:
| Student Name/ID | Start Time | End Lap Time 1 | End Lap Time 2 | End Lap Time 3 | End Lap Time 4 | Total Time |
| 13488 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 8:47 |
| 15567 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 10:15 |
| 45879 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 11:21:43 | 7:02 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My knowledge of Excel is very limited and any help would be greatly appreciated.
