hello
I recently got a bar-code scanner to read the VIN on cars being sent thru the carwash. My boss is also wanting to track the frequency of the cars, how often, how many per hour. thus i set the scanner to capture timestamps... i've set it up in this format...
0004.png
at the end of the day... i download all the information from the scanner via the dc console UI, which dumps them into an xls. when i open the file this is what i see...
0001.PNG
Unfortunately this is not the format that i want. it does not display AM/PM. i want 1:01:01 to show as 1:01:01 PM and 10:01:01 to show as 10:01:01 AM. it only displays AM/PM after i format the cells as time and manually retype the information. (i dont want to retype thousands of scans.
0002.PNG0003.PNG
the time stamps for this data set should range from 7:00 AM to 5:00 PM
thanks
Bookmarks