Google Sheets formula to convert FROM ordinal dates TO standard dates-CodePudding

Home > Back-end > Google Sheets formula to convert FROM ordinal dates TO standard dates

Google Sheets formula to convert FROM ordinal dates TO standard dates

Time：07-26

I am looking for a formula that will automatically convert a column of ordinal date/time values into standard date/time values.

July 1st 2022 6:48:49 pm
July 2nd 2022 10:03:35 am
July 3rd 2022 5:41:12 pm
July 4th 2022 2:44:13 pm

I need to get those reformatted to eliminate the st, nd, rd, and th portions.

Functions used: