Wanting to change Time UTC Format to Central Time

Welcome to the forum.

If your dates/times are real dates/times* then you can just add 7 hours like this:

Formula:

Please Login or Register  to view this content.

*Excel stores dates/times as numbers. Dates start with 1 being 1st Jan 1900, so 31st July 2019 is 43677. Hours are parts of a day, as decimals, so 12noon is 0.5, 6pm is 0.75, etc. Combining them means that 6pm on 31st July 2019 is 43677.75. You can check if your dates/times are real dates/times by changing the cell format to 'General'. If you get a number (for ex 43677.32495 for your first date/time) then you have real dates/times. If the cell stays the same (07/31/2019 7:47:56) then you have text which looks like a date.

If you have 'text dates/times' then you can convert them to real dates and times using 'Text to Columns' on the 'Data' tab.
Make sure you have a blank column B.
Select your cells (A2:A8), click 'Text to Columns'.
Choose 'Delimited' and click 'Next'.
Choose 'Space' and click 'Next'.
In the preview at the bottom select the 1st column, then choose 'Date' and 'MDY' at the top. Leave the second column as 'General'.
Click 'Finish'.

Now you will have two columns, one with dates and one with times, in A2:A8 and B2:B8.
Insert a new column C and put this in C2, then drag down:

Formula:

Please Login or Register  to view this content.

You can now add 7 hours to this column, using the very first formula I posted above:

Formula:

Please Login or Register  to view this content.

or you can copy C2:C8 and 'Paste Values' over A2:A8, then delete the now-not-needed columns B and C, then use the same formula with column A.

That was a long post, sorry - I hope it helps.