Format Spreadsheet - borders, font size/style, split text to columns

Hello,
I’m trying to write a code for a daily formatting process that I perform.
Attached is example 1 – beginning data (what the data looks like when I paste it into excel).

I need to:
(1) Delete the quality control column
(2) Separate the time column into separate a ‘date’ and ‘time’ columns (and fix the header accordingly)
(3) Set the time to a 24 hour clock
(4) Set the font to Arial, remove all bold font
(5) The first three rows are size 7.5. The rest of the rows are size 8.5.
(6) The entire table has a thin blue border between cells
(7) There is a thick black line at the end of the data
(8) All row heights are 15
(9) Column width should be automatically adjusted to fit whatever the maximum length of text in a given cell (which may vary daily). (text should not be wrapped, it should just fit across)

I’ve also attached example 2 –finished data (what the data should ultimately look like).

My current (amateur) attempts to accomplish this are attached as ‘code attempt’.

Thank you for any advice and wisdom you might be able to share!

Hi Orrin,
Thanks for your help! This is great!

One tweak I would like to make is that sometimes the columns vary and don't always go to "U". (sometimes they are only to Q)

Is there are way to set the T range for the borders to count to the last filled column before drawing the borders?

Thank you!

This is absolutely perfect!

Thank you so much