OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Google spreadsheet - how to determine timezone using function

  • Thread starter Thread starter wivku
  • Start date Start date
W

wivku

Guest
How to use a formula to determine the current timezone? The formula I use gives an unexpected result.

My spreadsheet settings (File > Spreadsheet settings...):

Code:
Time zone: (GMT+01:00) Amsterdam

The formula I used:

Code:
=TEXT(NOW(),"HH:mm z")

This gives:

Code:
12:47 GMT

Local clock time is 12:47, I would expect the formula to show: 12:47 GMT+1.
I also tried Z instead of z, which gives 12:47 +0000, I would expect +0100.

Any suggestions?

I need this, so I can determine UTC time and convert to Epoch time

Code:
"UTC time" - DATE(1970,1,1)*24*60*60

Continue reading...
 

Latest posts

B
Replies
0
Views
1
Blundering Ecologist
B
Top