title: Convert decimal number to minutes and seconds using VBA
body: <p>I have time represented by a decimal number that I need to convert to minutes and seconds in Excel using VBA.</p>
  
  <p>Example: 
  The number before the decimal point gives the minutes as 0.197683577  (0 minutes)
  and the number multiplied by 60 gives the seconds = 0.197683577*60 = 11.86101462 (12 seconds)
  = 0:12</p>
  
  <p>I know I could do this by copying and pasting into text format and separating the number to the left and right using text to columns of the decimal point and then add ":" in between but there must be a way to calculate this.</p>