Formating hours and minutes into 24 hour

HI, I am trying to format hours : 7:00PM with the formula =TEXT(A5,"[hh]:mm"), which will display the hour into : 19:00 (24 hour format). However, I have the 'minute' part of the data in another c...