title: Split Date and String in Excel VBA
body: <p>I'd need to get an amount of hours from data in the following format:</p>
  
  <pre><code>'166:05 hod:min'
  </code></pre>
  
  <p>The first number is the amount of hours, next after <code>':'</code> are minutes. The rest can be thrown away. </p>
  
  <p>My idea was to split the first number, add the second number divided by <code>60 [166:05 -&gt; 166,08]</code>, but I'm the very beginner of VBA and these things.</p>