Paul,
I'd say challenge is exaggerating a bit:

SELECT cast((END_TIME-START_TIME)*4 as Integer)/4
FROM your_table

Or did I miss something?

HTH,
Set

At 11:54 29.01.2001 -0500, you wrote:

>
>Here is an interesting challenge to all.
>
>ITable that contains two time values, START_TIME and END_TIME, now I
>want to calculate the number of hours difference between them, with a
>slight twist, according to the following table:
>
>Minutes Start-Time End-Time
>
>< 15 0.0 0.25
>16 - 30 0.25 0.50
>31 - 45 0.50 0.75
>46 - 59 0.75 1.00
>
>So from 14:03 to 14:58, would be calculated as from 14.00 to 15.00
>and return 1.00 hours.
>
>I know that the stored procedure for this, is going to win an ugly
>contest, but I would like to be able to keep the actual physical
>times, as well as the "rounded" times.
>
>Paul
>
>
>Paul Schmidt,
>Tricat Technologies
>Email: paul@...
>Website: www.tricattechnologies.com
>
>
>
>
>