I have a decimal field in a SQL database that stores time only. Below is the data that is coming across and the end result I would like to display in a SSRS report. The solution could either be in the SQL query or maybe some type of SSRS formatting/expression.
Data Desired Result
6.50 6:30:00 AM
14.25 2:25:00 PM
17.75 5:45:00 PM
8.00 8:00:00 AM
I greatly appreciate any help with this.