posted 12 years ago
Hi all, I am Chaitanya, I am sorry if I post a wrong question here.
I have a google spreadsheet, where there is a column to store the an event's time.
Suppose that it is 16:45:00.
When I use google app script to retrieve the cell's value like:
var a=dataSheet.getSheetValues(144, 1, 1, 7);
new Date(time).toTimeString()
it is showing
14:38:24 GMT+0530 (IST).
My spreadsheets timezone is (GMT +08:00) Hong Kong.
I know that due to the spreadsheets timezone and my browser's timezone, I am getting an unexpected value.
Can anyone tell me how to retrieve the exact time i.e. 16:45:00.
Thank you all in advance.
Love all, trust a few, do wrong to none.