title: Convert days to hours in HHH:MM:SS Format (Nvarchar)
body: <p>I have a table where i need to convert for example 2.6 days or 5 days, 3.2 days etc to hours. Since it is above 24 hours format i know i need to convert to nvarchar. I searched many forums and i cannot see exactly how can i do specifically this, i think i have to convert this days to seconds and then from seconds to nvarchar format. does anyone have any idea?</p>
  <p>Thx all :)</p>