Convert number field to time field 1

[mellicks]

I am having issues with a field in a database. The field is a number field, but it contains appointment times. For example, 800, 810, 815... 1515 mean 8am, 8:10 am, 8:15am, 3:15pm. I have to do calculations on these times now, so I'm trying to convert the number to a time and can't get it to work.

Any suggestions would be greatly appreciated!
Thanks,
mellicks

 

[lbass]

stringvar x := totext({table.number},"0000");
stringvar y := left(x,2)+":"+mid(x,3)+":00";
time

-LB