The formula you need to you is of the form

```
=(A1/"0:0:1")*100
```

**Explanation**: Essentially we are dividing a time by one second, converting it to seconds, and then multiplying it by 100 to get the centiseconds.

Note: Make sure the format of your column is a number if the result doesn't work. `A1`

is just a placeholder for whatever cell you want to use. Also I believe your conversion is wrong.

### If the excel SECOND function returned a floating-point number:

Generally, if you know how to extract minutes and seconds, creating a formula is very straight forward. You know there are 60 seconds in a minute and 100 centiseconds in a second, the total number of centiseconds should be

```
=MINUTE(A1)*6000 + SECOND(A1)*100
```

However the excel `SECOND()`

function only returns integers, and there are no functions that return smaller time steps, so it does not work this way.