Many thanks for your response.
I have changed the datatype to single line. But the code given below is not getting converted. When I am using the post meta inspector i get the value as entered.
Can you please help
add_action('cred_save_data', 'msconvert', 10, 2);
function msconvert($post_id, $formdata){
if ($formdata['id']==11856 or $formdata['id']==11862)
{
Well, that part of the Code is not using Toolset schemas, data or API.
It is entirely related to Custom PHP.
If it does not work with a Single Line, it will also not work with any other field type.
I cannot code that for you, I can, however, point you to the mechanisms that you need to use.
If you are still submitting values like 1:30,40, and so on, you need to get that data raw first.
This is done with the get_post_meta().
Once you have that value, you use PHP to remove the; and, signs.
This is done with str_replace(). hidden link
Then, after you replaced the; and, with "nothing" (str_replace("to_replace","with_what_to_replace","in_what_context");), you will have a raw numeric string.
This looks like 123456 instead of 12;34,56.
This value can then be calculated to seconds, if it represents milliseconds, by dividing it by 1000.
(as 1000 milliseconds, divided by 1000 is 1 second, right?).
Then you use update_post_meta() to create/update the real Post Field with this new value.
You will either create a View, and order the View by that field, and order it as ascending, return one result only.
That will show the lowest numerical value only, hence, the best time only.
To distinguish by type, which if I recall right is a Taxonomy, I recommend a Custom Filter by that taxonomy where the Visitor can filter by the type.
The result is still one and updated by the kind of race.
If this is not suitable, please open a new ticket, with one issue only given the new data you have now.
This will allow us to focus on the new topic environment correctly.