reporting services - SSRS: Convert decimal to hours and minutes -

reporting services - SSRS: Convert decimal to hours and minutes -

i have study want display time in hours , minutes (17hrs 30 mins)

the dataset returns value in decimals (eg 17.5)

how convert decimal format specified above (17hrs 30 mins). there kind of built in function can easily?

this works particular example:

=floor(fields!myvalue.value) & " hrs " & cint((fields!myvalue.value - floor(fields!myvalue.value)) * 60) & " mins"

you may need tweak possible scenarios should starting point.

reporting-services ssrs-2008 reportingservices-2005