title: How to fix hh:mm format
body: <p>I have an Excel file imported from a specific information system. I have been working with its automation through VBA code. However i encountered a problem while dealing with hh:mm cells. I can't sum them up, I tried formatting them to hh:mm, I also tried to format my output cell as [HH]:MM, none of it seems to work.</p>
  
  <p>I guess the problem is with how the cells are formatted, they are in Times New Roman and seem a bit off.
  I need a vba code to select a certain range and copy the ancien value and paste them again, but with the normal default Excel formatting.</p>
  
  <p><a href="https://i.stack.imgur.com/T5uZy.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T5uZy.png" alt="enter image description here"></a></p>