Converting times to a different time zone

Hi I have times in a custom column formatted such as 8:00 PM and 12:50 AM and so on.
The time zone is GMT +10
I need to convert the time to GMT +2
So basically 8 hours less.
I have tried some things that just don't work. Is this possible to do please?
Our internet is affected by the massive floods near Brisbane Australia so I am on my mobile. Thanks for any help.
Doug

Thank you Jeffrey. It worked great. Could i ask for an extra step in converting the requied time to 24 hour format please. Not a prblem if i need an extra column. Reps added anyway. Thanks again

Originally Posted by jeffreybrown

Hi Doug,

You could use >> =TIME(HOUR(A1)-8,MINUTE(A1),SECOND(A1))

Notice the minus 8 for the first hour argument

Hi Richard made the reply to jeffrey just after your post.
Thanks for the modification. Tested it also and works perfectly. Cheers doug

Originally Posted by Richard Buttrey

...if times in A1 are less than 08:00:00 then you may need a slight modification to Jeff's formula.

=TIME(IF(A1*24<8,HOUR(A1)+16,HOUR(A1)-8),MINUTE(A1),SECOND(A1))

Thanks jeffrey. Really helped me out with this.
Cheers doug

Originally Posted by jeffreybrown

Just change the custom format
Custom Format

• Right click cell (or Ctrl + 1)
• Format Cells
• Number
• Custom
• Type: hhmm

Cant see the add reputation on my phone . I will revisit when i have internet back for my pc and fix it for you guys

Updated the reps - can't find the solved box

Found it -