Change transaction time on stock market trade data

I trade US & Australian stocks and get the transaction data from my broker which I download into third party software (Tradervue) which I use to review my trades. However due to a recent change by the broker, the data I download for US trades now has the Australian time as the execution time, rather than the US time that the trade was executed. I am wanting the time for US trades converted back to US time so that it makes sense on my third party software. Below is an example of the format that I receive from my broker STK_TRD|5117478|BOOT|BOOT BARN HOLDINGS INC|NYSE|BUYTOOPEN|O|20191112|06:18:57|USD|2.00|1.00|40.96|81.92|-1.00|1.4624 This is the date & time portion of the trade 20191112|06:18:57 and needs to be adjusted back 16 hours for the time difference between Sydney & New York. so the above will become 20191111|14:18:57 Note that there will be some Australian trades which will not need any adjustment, but the majority of trades will be US trades that will require adjusting. Australian trades are denoted with ASX code as seen in the trade below. STK_TRD|5157509|NXT|NEXTDC LTD|ASX,CHIXAU|BUYTOOPEN|O|20191115|13:56:10|AUD|900.00|1.00|6.88|6192.00|-6.60|1.00 I want to be able to convert this on a regular basis (at least weekly) as I am an active trader and there could be a couple of hundred lines of trades each week. Ideally I would like an excel template (or something similar) that will easily and quickly convert the data so I can download into my third party software. Please let me know if you require further clarification of what I need. Thanks Michael