ohadyemini
11-08-2014, 06:55 AM
Hi guys, I have a problem and i wish someone here can help me, i searched the web and this site but i didn't found an answer.
I have a table with swimming time for each participant.
The grade is base on a ladder-scale.
If your score is between 15:00 to 16:30 you get 80
If your score is between 16:31 to 17:30 you get 85
you get the point..
i want to calculate the grades for ever participant.
how do i do that using vba?
The main trouble i have is how to represent the scale in vba
and how do i find out if the time given is between a range?
Notes:
I am using excel 2007
The Cells are in the format of 30:55.2
Please Help Me!
I have a table with swimming time for each participant.
The grade is base on a ladder-scale.
If your score is between 15:00 to 16:30 you get 80
If your score is between 16:31 to 17:30 you get 85
you get the point..
i want to calculate the grades for ever participant.
how do i do that using vba?
The main trouble i have is how to represent the scale in vba
and how do i find out if the time given is between a range?
Notes:
I am using excel 2007
The Cells are in the format of 30:55.2
Please Help Me!