Your sample shows only times. That's not much to go on. As a guess:

-- to "remove" a format, change it to any other, like General or a numeric
format.
-- if you are asking how to convert a time to a number of, say, minutes,
multiply by 1440 and format as a number.

Regards,
Fred.



"Jesse" wrote in message
...
how to remove existing format, like time to regular number see sample
:30.8 :58.8 1:28.4
:27.8 :57.2 1:26.2
:31.0 1:00.4 1:29.6
:32.4 1:02.2 1:31.4
:30.0 1:00.8 1:32.2
:28.4 :57.6 1:28.0
:28.2 :58.2 1:28.4
:30.8 1:01.8 1:31.8
:31.6 1:01.8 1:31.4
:28.8 1:00.2 1:29.8
:32.4 1:02.2 1:31.4
:30.0 1:00.8 1:32.2
:30.2 :59.4 1:29.8
:29.8 1:01.4 1:31.2