title: How to convert seconds into hh:mm format in Power Bi?
body: <p>In Power Bi, I have a table that contains <code>Name</code> and <code>TimeSpent</code> by user in seconds.
  I want to convert total seconds spent by all users into duration format <code>(hh:mm)</code> </p>
  
  <p>When I am getting seconds in hh:mm format for each user from database query, the values are coming up like these <code>12:63</code> etc. After importing these values into power bi, I tried to set its datatype to <code>DateTime</code> format but power bi shows an error saying that it is not a valid value. If I set the datatype of the column as <code>string</code> then strings dont add up. </p>
  
  <p>What can be the ideal way to do it?</p>