jhonbust
New member
- Joined
- Aug 20, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I have a question that I think might be fairly simple to answer.
How to generate an identification number sequence using as a basis the date and time that is placed in the "Date of occurrence - Day and time" boxes. That is, the identification number is determined by the date and the sequence will be according to the dates and time that are placed in the "date of occurrence" and "Time" boxes.
For example:
Is this possible?
How to generate an identification number sequence using as a basis the date and time that is placed in the "Date of occurrence - Day and time" boxes. That is, the identification number is determined by the date and the sequence will be according to the dates and time that are placed in the "date of occurrence" and "Time" boxes.
For example:
ID Number | Date of occurrence | Time |
08/19/2019 | 10:00am | |
08/19/2019 | 09:20am | |
08/20/2019 | 08:00am | |
08/21/2019 | 04:00pm | |