I have a series of IDs that are represented in a column with the [h]:mm:ss format in excel. I want to extract the [h] portion that precedes the colon and have it stored as a number. The problem I run into is that it converts the digits to a new number, not the digits as displayed.
Example: 1234:00:00 formatted as [h]:mm:ss Desired text in new column: 1234
I am looking to use a straight formula to solve.