Hi!
This is my very first time to post a question, so please excuse any errors.
I have a list of numbers with extentions, basically they are reference numbers for actvities. They are generated through a report and show up like this 1-1105-1, 1-1105-2, 1-1105-3, etc., What I am looking for is to auto fill the adjacent cell with the time, so it would read as 1-1105-1 in cell A1 and 8:30 AM in Cell B1.
Here are the list of extensions (the first digit will always be 1dash "-", the next four could change, followed by another dash "-", and then the digits
-1 8:30 AM
-2 9:00 AM
-3 10:00 AM
-4 10:30 AM
-5 11:30 AM
-6 12:00 PM
-7 12:30 PM
-8 1:30 PM
-9 2:00 PM
-10 2:30 PM
Thank you very much.
Bookmarks