Convert non standard time formats to a standard time format

Hi
I have a column over 10,000 records of time in excel some are sorted as original time format of excel and some are mentioned as text and some as numbers ex(10.0, 3.30 etc.,)
in this situation How can i convert the time non standard time formats to a standard time format with out changing the time value.

I tried the following formulas but not getting correct results;
1. =TEXT(LEFT(A1,2)&RIGHT(A1,2)/24,"h:mm am/pm")
2. =IF(ISNUMBER(A1),A1,TIMEVALUE((A1)))

please suggest formula to resolve this

Thanks and Regards
Sandeep Vemula

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Read the yellow banner, top of page, and post a sample Excel sheet with a fully representative range of examples.

Try this:

=IF(LEN(B2)<8,(INT(B2)/24)+((B2-INT(B2))/14.4),B2)

Set the column formatting to TIME.

What's your point? This suggestion works on the OP's sample.

self deleted by user

Sorry - I don't get your point. Do you have any suggestions yourself?

@huuthang_bd
It appears in desired output that OP expect #.40 as #h.40 m,
11.50 as 11h50m
You are translating 0.5 to be 1/2 day = "12:00:00", it should be "0:50" as per the OP's logic.

Please try at D2
=IF(--TEXT(B2,"h:m:s")=B2,B2,DOLLARDE(B2,6)/24)

@bebo
I didn't translate anything. I think he want 0.50 will be converted to 00:50:00 and 12:00:00 will not change, but the formula return the same results.

You are going to need to provide a better set of sample data and expected results.

However, you seem to have an alternative suggestion that works for you, so it's a moot point.