Avatar of Mehawitchi
Mehawitchi
 asked on

Convert Number to Time - SSRS

Hello Experts,

I have a column which is double data type and it represents a time duration.

I need to convert it into h:mm format in an SSRS report.
For example, the following values are converted in Excel into time

Value Double        Time h:mm
0.2820                      6:46
0.2801                      6:43
0.2835                      6:48
0.2894                      6:56
0.2971                      7:07
0.3027                      7:15

Unfortunately, unlike Excel SSRS doesn't allow conversion from Double to Time

Appreciate your help in solving this problem
SSRS.NET Programming

Avatar of undefined
Last Comment
Mehawitchi

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jacques Bourgeois (James Burger)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mehawitchi

ASKER
Thanks James - I was able to solve the problem based on your suggestion
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy