Home > Software engineering >  VBA recognition is not the case, how to extract the minutes
VBA recognition is not the case, how to extract the minutes

Time:11-19

Format (ThisWorkbook. Sheets (" sheet1 "). The Cells (p. 19), and "m")

I use the above code, ready to extract the minutes, the result is out in
How broken???????

CodePudding user response:

Right (the Format (ThisWorkbook Sheets (" sheet1 ") Cells (p. 19), "hh: mm), 2)

CodePudding user response:

The
reference 1/f, crispy big ice cream reply:
right (the Format (ThisWorkbook. Sheets (" sheet1 ") Cells (p. 19), "hh: mm"), 2)

Solved, excelVBA minutes is nn not mm
  •  Tags:  
  • VBA
  • Related