Hyperlinks for noobs

I am currently working on a photo database using excel. I have the rows set up and linked. Now I just need a way to create roughly 3000 hyperlinks.
A ----------------B-----------------------C----------------------D-------------------E----------------------------- F
John-------------Smith------------------Operations------------Security-----------10/22/2012----------------P121
When I click on the data from column "F" I want it to open the photo (not the folder).
All of the photos are in the same folder in a networked drive and they are all numbered. All of the numbers associated with the names are in column F. I could go through an manually make hyperlinks for each photo but I would rather not spend a week on the task. Any help would be appreciated.

I am a complete beginner in excel, but ill try to give a bit more detail. Any instructions will probably need to come with a for dummies how to section.
There are roughly 3000 rows of names of employees. Each row has 6 columns and contains the same information for each employee. The "F" column contains the photo number that corresponds to a photo in a folder containing about 3000 photos. What I would like to know is how do I hyperlink each photo number in excel with the actual .jpg in the folder. The photos each start with the letter P and are numbered P1 to P3000.
The photos are located in - K:\PIC
For shoots and giggles we can say the excel document is saved - C:\Users\Main\Desktop\Test
In the A1 to F1 I put the title for each column in it. (First Name, Last Name, etc. ending with "F" which is "Photo Number").
If you need any other variables please let me know, I'm siked to see this project finally completed lol.

I solved it with a work around.