title: Userform time format problems
body: <p>Ok, so i have been working on a project for a while now. And its almost done. But i keep having small issues that i cant solve. This time its a formatting issue. </p>
  
  <p>Short and simple:
  I have a table in sheet1(database) of information that i display in a userform (see image) <img src="https://i.stack.imgur.com/CaoBk.png" alt="Sheet1"> <img src="https://i.stack.imgur.com/dK9HI.png" alt="Userform">
  There are several approaches to add a new line in the database, you can add it manually by filling all the empty text boxes, or you can double click an existing row and the text boxes fill them self. My problem is when i double clicking existing row, time format changes. see image. <img src="https://i.stack.imgur.com/mrEW6.png" alt="image2"></p>
  
  <p>I solved that using this code:</p>
  
  <pre><code>Private Sub Reg5_Change()
  Reg5.Value = Format(Reg5.Value, "hh:mm")
  End Sub
  </code></pre>
  
  <p>But then i have trouble doing it the manually way. When i try to type in time i end up getting 00:00 and having trouble changing it.</p>
  
  <p>Is there a way to solve this so i can use both methods for adding new row in database? </p>
  
  <p>Other questions:
  I want the textbox ETA to contain ETD + EET. <img src="https://i.stack.imgur.com/MA3k2.png" alt="Image3"></p>
  
  <p>I tried this with a result of 08:02 when ETD = 08:00 and EET = 02:00. Seems like EET is added as minutes. </p>
  
  <pre><code>Private Sub Reg7_AfterUpdate()
  Reg7.Value = Reg5.Value + Reg6.Value
  end sub
  </code></pre>
  
  <p>Update: </p>
  
  <pre><code>Private Sub Reg7_Change()
  Dim etd As String: etd = Reg5.Value
  Dim eet As String: eet = Reg6.Value
  
  Dim detd As date
  Dim deet As date
  
  detd = TimeSerial(Split(etd, ":")(0), Split(etd, ":")(1), 0)
  deet = TimeSerial(Split(eet, ":")(0), Split(eet, ":")(1), 0)
  Reg7.Value = detd + deet
  end sub
  </code></pre>
  
  <p>Getting this error <a href="https://i.stack.imgur.com/nlNXU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nlNXU.png" alt="Error"></a>
  But as you can see in the image the time is correct and that part is working correct. </p>
  
  <p>hope there is someone out there who can help me out</p>