CODEWITHSUNDEEP
google-sheetsgoogle-sheets-api
Aniruddh Chaudhari
Aniruddh Chaudhari

Reputation: 113

Convert UTC to CST time zone in google spreadsheet

convert date & time into CST time-zone I want to convert given date & time into CST time-zone any formulae or script which i should use and i also want to convert it into IST time-zone..

Upvotes: 0

Views: 16406

Answers (1)

user4039065
user4039065

Reputation:

This should work for UTC->CST (UTC -06:00) in either or .

=A1-TIME(6, 0, 0)

For UTC->IST (UTC +05:30) use,

=A1+TIME(5, 30, 0)

Note that one subtracts and one adds. You cannot generate negative time with the TIME function.

Upvotes: 2

Related Questions