# I have to convert the given value into the format " Days:HH:MM:SS " in SSRS report

I have to convert the value into    DDD:HH:MM:SS   format.

For example
if I get the value 241 ,   I have to convert it into 10:01:00:00

When > 24 hours, to use number of days

DDD -days
HH -Hours
MM -Minutes
SS -Seconds

How to do it in ssrs expression?!
###### Who is Participating?

Commented:
it should work , try to use each part at a time and then keep on adding one by one if the earlier one works
0

Commented:
what is the value 241, is it minutes, days or hours or seconds? based upon that we should write the function
0

Author Commented:
Suresh,
Its minutes
0

Commented:
declare @mint int   /*  minutes */
set @mint = 3456

Select @mint,
Cast(@mint / 1440 as Varchar) + ':' +
Cast((@mint%1440) / 60 as Varchar) + ':' +
Cast(@mint % 60 as Varchar)
0

Author Commented:
Suresh,

I asked it in the SSRS expression , not in the sql stmt.
Is it possible to add in ssrs?!
for ex
0

Commented:
yes, same logic you use it in ssrs expression by concatenating it in a expression of a text box
0

Author Commented:
How to do that suresh?!

Now in the textbox, i'm displaying the following,

=Last(Fields!I_TIME_ON_GPS.Value)

Can u tell me how to change the "I_TIME_ON_GPS.Value"  value into "DDD:HH:MM:SS"    format
0

Commented:
try this in expression

CChar(Fields!I_TIME_ON_GPS.Value/1440) + ":" + CChar((DivRem(Fields!I_TIME_ON_GPS.Value,1440))/60) + ":" + CChar(DivRem(Fields!I_TIME_ON_GPS.Value,60)) + ":00"

the ":00" in last is for seconds, as the number is in minutes, you cannot divide them into seconds
0

Author Commented:
No Suresh,

It shows the error as "wrong number of arguments" in the following part

CChar((DivRem(Fields!I_TIME_ON_GPS.Value,1440))/60)

0

Commented:
Replace DivRem(Fields!I_TIME_ON_GPS.Value,1440)   to Fields!I_TIME_ON_GPS.Value Mod 1440

and

DivRem(Fields!I_TIME_ON_GPS.Value,60) to Fields!I_TIME_ON_GPS.Value Mod 60
0

Author Commented:
Its showing error only.

Is it working in ur side?!
0

Author Commented:
I use like the following,

Fields!I_TIME_ON_GPS.Value \ 1440  & ":" & Fields!I_TIME_ON_GPS.Value \ 60 & ":" & Fields!I_TIME_ON_GPS.Value mod 60

Its working,  Thanks suresh for your idea.
0

Author Commented:
It helped me partially
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.