Time calculation field

[lemmas]

I have a calculation field that I want the result is time. I have an ID number for each record, I want the calculation to take the ID number, look at the last digit and put in a time in this field dependant on the last digit. In my calculation I have:

Case(Middle(ClassID, 6, 1)=1, "10:00",

Middle(ClassID, 6, 1)=2, "1:00",

.

.

.)

This works if the result is text. As time I get unusual results. A time value is entered by the values are extremely off and there appears to be no pattern as to the time difference. I have tried entering the time in different formats; hh:mm:ss, hh:mm, military time, with and without am/pm, all with no success. What am I doing wrong?

Thanks,

Nick Trenary

Cedar Rapids Public Library

[-Queue-]

Time( Choose( Middle( ClassID, 6, 1 ) - 1, 10, 1, ... ), 0, 0 )

If 1 is 1 pm, use 13 instead of the 1 following 10.

[lemmas]

Ah, yes. That did it. Thanks -Queue-!