Entering Date/Time values that include a timezone offset into Date/Time fields?

You will need to take in that raw data into a field.
Then parse out the date and the time and the offset into either three fields or done by formula variables inside a formula date time field.

Then build a formula do what you want with that info.

ie, Quick Base will not magically recognize that syntax.

Post back if you need help to parse out the components into three fields.