Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keungk
Starting Member
2 Posts |
 Posted - 2008-04-28 : 11:03:52
|
| In Reporting Services, I have a decimal time field (18,2) in my report which I wish to display as HH:MM. Similarly, I req a sum of total hours and minutes as a summary. Whats the expression for doing this. I've googled far and wide and cannot find a definitve solution.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-28 : 11:10:52
|
| try with format expression ="##:#0"how are getting time value in your dataset? as a datetime field or integer field? |
 |
|
|
keungk
Starting Member
2 Posts |
Posted - 2008-04-28 : 11:20:16
|
| its just a decimal field, but trying your expression i get3.75 --> :4I would like 3:45 to be displayed. |
|
|
|
|
|
|
Converting decimal time to HH:MM