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?