How to display an integer to a time format

[kate8]

Hi All,
I have a field which suppose should store time, but instead they all are integers. For example, 1400 is 2:00 pm, 1100 is 11:00 am, 930 is 9:30 am,etc. Now in my report, I need to display them as Time. How can I display 1100 as 11:00 am, 1400 as 2:00 pm. I tried to use Text Box Properties, but since they are not time format, it didn't work.
Thank you so much for any ideas/suggestions!!!

 

[kate8]

Hi,
I figured it out. This is how I do it:

=Switch (
Fields!APPTIME.Value > 0 AND Fields!APPTIME.Value < 1000,Left(Fields!APPTIME.Value,1)+":"+Right(Fields!APPTIME.Value,2) + "am",
Fields!APPTIME.Value > 1000 AND Fields!APPTIME.Value<1200,Left(Fields!APPTIME.Value,2)+":"+Right(Fields!APPTIME.Value,2)+"am",
Fields!APPTIME.Value > 1200 AND Fields!APPTIME.Value<1300,Left(Fields!APPTIME.Value,2)+":"+Right(Fields!APPTIME.Value,2)+"pm",
Fields!APPTIME.Value = 1200,Left(Fields!APPTIME.Value,2)+":"+Right(Fields!APPTIME.Value,2)+"pm",
Fields!APPTIME.Value >= 1300,(Left(CStr(Fields!APPTIME.Value-1200),1))+":"+Right(Fields!APPTIME.Value,2)+"pm"
)
Since there is no appoinment time after 18:00, so I didn't do APPTIME.Value >= 1300 and APPTIME.Value < 2200.