Ok so I am trying to input a list of times with names attached under 4 headings then depending on where they are input either 0,5,10,or 15 seconds is added and a list of the new times under each heading is made. The idea is the then take all those times listed and order them from largest to smallest according to the time but include the original name.
The problem is I cant figure out how to stick the names in b5,b6,b7 etc to the formula adding the time =SUM(C5,E5) , =SUM(C6,E5), =SUM(C7,E5) etc etc =SUM(C23,F5)....so that is reads something like 08:43:26 "Name"...since I havn't gotten through that step I havn't even started on how I take those values in 4 colums and mix them into one list in order of highest number to lowest with the names included beside them.
Ive looked for the way of doing it but can't seem to find it and when I thought I got it I just get a long decimal number instead of the time and name....
Any help would be great!
Thx for your time.
Bookmarks