Hey guys, me again.

quick question.

I have a spreadsheet dealing with times, but they are represented in a
strange way. i.e.

If someone inputs 17:30 (5:30pm (half way between 5 and 6 pm)) the would
type it as:

17.30

Now i need this number (17.30) represented as a 100 based number so it
becomes:

17.50 (half way between 17 and 18)

An increase of 0.20, easy, but when the number can change to say 17.15, the
number then needs to be 17.25 (quarter past) this is an increase of 0.10.

So what i am asking is, does anyone know how to change numbers based on 60
(time) to number based on 100 via a calculation that can be applied to any
number in the 0 - 60 range resulting in a number from the 0 - 100 range?,
with the correct result being output.

I dont kow if this can be done using a ratio, or some strange VB function i
dont know about, but any help would be awesome, if you dont know what i am
rambling about then please feel free to ask a question.