Time Zone Converter

[ThinhDinh]

Hi Gavin,

You can get an idea from what Ray did here. Capture the time and the UTC, then do a calculation to fit your need.

Converting "-07" text to "-7" number value in google sheets

Anyone know how to convert “-07” text to “-7” number value in google sheets? Been hitting a wall with this, can’t find the solution on Google. here’s the error i get [image] I tried =text(A1,"#") but doesn’t seem to work. It spits out the same value with the leading zero “-07” I’m trying to do a calculation using a column of numbers that have been stripped out of a string eg. “-07” stripped from UTC-07

Feel free to ask us if you need help.