title: Convert timespan into hhh:mm:ss to insert into mySQL time type fields
body: <p>This seems like a newbie question but I am really struggling with it.</p>
  
  <p>I have a time field in mysql database.  I am using vb.net 2012.  I am trying to insert amounts of time into the time field.  I've settled on using a text box and having the user enter the amount of time as a decimal (1:30:00 = 1.5).  My problem is that these timespans can be over 24 hours long and vb wants to convert it into a format that contains days.</p>
  
  <p>ex.  100.5 hours gets converted to 4.04:30:00</p>
  
  <p>I would like it to show as 100:30:00 so that I can insert it into my database.</p>
  
  <p>I'm open to alternate suggestions.</p>
  
  <p>Please help me.  I've wasted more than enough time on this.</p>