excel time digital

Users questions: As shown in the annex, I use the & and Hlookup formula, would want it to appear as the time format, and finally turned into numbers. What if the solution, thank you.
Experts answer: = "first class" & TEXT (A2, "hh: mm") This is the points = "first class" & TE XT (A2, "hh: mm: ss") This is the second to use this formula on the line, but that first class, second class, third class to pull something to add their own custom sequence, otherwise It does not follow the law down, and only lost that one by one, be sure to lose the English colon colon accessories: After using the formula into a number of issues of time. Xls
  • This information provided by the users.Thanks!