Hey @jappleii
Can you provide more details for what you're looking to do? The Time Function can reference one Text/Number time cell and add hours on to that time to display a different timezone in another column, if that's what you're looking for?
Keep in mind the System Date columns (Created and Modified) will display time based on the user's timezone set in their Personal Settings, if that helps.