Numeric to time format

[esanray]

Numeric to time format
1500 to 15:00

[HalfBloodPrince]

First convert time column  it to varchar using cast( [Time], varchar(10)) then

create new calculation as  new time as  cast(substring([Text Time],1,2)+':'+substring([Text Time],3,4)+':00',time)

thanks,