Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Jul 12, 2010 5:46 am**

I use version 2007.2 and used this code to convert minutes stored as integer to HH:MM

,(Select convert(varchar(5), crmActivity.NetTime/60)+':'+convert(varchar(2), crmActivity.NetTime%60)) AS DisplayTime

But if the value does not have minutes left (e.g., NetTime = 60), I get a value of 1:0. How do I get it show as 1:00?

Posted: **Mon Jul 12, 2010 6:57 am**

Hello,

You can use following expression:

Code: Select all

{Today.ToString("HH:mm")}

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Minute to HH:MM conversion

Minute to HH:MM conversion

Minute to HH:MM conversion