Getting time from a cell in Google Spreadsheet

Posted by lostInTransit on Stack Overflow See other posts from Stack Overflow or by lostInTransit
Published on 2010-06-07T13:27:52Z Indexed on 2010/06/07 13:32 UTC
Read the original article Hit count: 143

Filed under:

JavaScript

|

google-apps-script

Hi

I have created a Google Spreadsheet form in which for one of the fields I get the time (hh:mm:ss) in 24-hour format.

I am using Google Apps Scripts to read values from this spreadsheet and put it into another file. But the other file gets the entire date (don't know from where) and shows a date from 1899. Also the time is shown in PDT (not my time zone). Even the time it prints is not correct

How do I

read the column value as a string and put it in the other file OR
get just the time from the column value (and the correct time)

I am using a simple row[0][3] to get the values from an array after doing range.getValues()

Thanks.

© Stack Overflow or respective owner

Related posts about JavaScript

CHAT ROOMs 7 by 6

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for chatroom on one page with 7 loggedin users and 6+rows for say 42 users.these users will keep on adding wthnew users.Need urgent help.A PRETTY UNUSUAL Q FOR MOST OF U.What is MORE REQ new features: Usernames are unique to users currently chatting You can see a "currently chatting"… >>> More
Integrating JavaScript Unit Tests with Visual Studio

as seen on Stephen Walter - Search for 'Stephen Walter'
Modern ASP.NET web applications take full advantage of client-side JavaScript to provide better interactivity and responsiveness. If you are building an ASP.NET application in the right way, you quickly end up with lots and lots of JavaScript code. When writing server code, you should be writing… >>> More
Has Javascript developed beyond what it was originally designed to do?

as seen on Programmers - Search for 'Programmers'
I've been talking with a friend about the purpose of Javascript, when and how it should be used, etc. He quoted that: JavaScript was designed to add interactivity to HTML pages [...] JavaScript gives HTML designers a programming tool HTML authors are normally not programmers… >>> More
PHP, javascript, single quote problems with IE when passing variable from ajax post to javascript fu

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I have been trying to get this to work for a while, and I suspect there's an easy solution that I just can't find. My head feels like jelly and I would really appreciate any help. My main page.php makes a .post() to backend.php and fetches a list of cities which it echoes in the form of: <li… >>> More
Javascript in XSL that is loaded by Javascript

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there anyway to have javascript run when a XSL sheet has been applied to an XML file by Javascript? I am using a JQuery plugin to apply the sheet to the xml but the javascript that is located inside of the XSL file will not run. I put the Javascript at the bottom of the file and it still does… >>> More

Related posts about google-apps-script

Any specifications/docs around optimization of Google Apps Script, to avoid timeouts and "hangs"

as seen on Stack Overflow - Search for 'Stack Overflow'
From my experience so far, it seems that if you write a script that makes lots of expensive calls close together, the functionality just "hangs", or you get inconsistent responses, and have to refresh the browser because sheets stop updating etc. Are there any docs or specs that clarify this, as… >>> More
Automatically Generate Maps and Directions with Google Apps Script

as seen on Google Code - Search for 'Google Code'
Following up on our recent post about the new Doc List capability in Google Apps Script, we thought we’d take a moment to look a little more closely... >>> More
Google I/O 2012 - Putting Together the Pieces: Building Apps with Google Apps Script

as seen on Google Code - Search for 'Google Code'
Google I/O 2012 - Putting Together the Pieces: Building Apps with Google Apps Script Saurabh Gupta Learn what's new with Google Apps Script. This session will explore the simplicity of Google Apps Script to build an app that integrates across many Google services. Many of the Google Apps Script… >>> More
svn path in google apps script

as seen on Super User - Search for 'Super User'
Hi, I want to write a google apps script in google docs spreadsheet, such that it should update the svn revision of particular component automatically (which is in one cell of that spreadsheet) when i run that script >>> More
Google Apps Script - Sending Google Spreadsheet Row to Email

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to write a script using Google Apps Script (Javascript) for a Google spreadsheet. I am trying to do the same thing that is shown in this tutorial [http://www.google.com/google-d-s/scripts/sending_emails.html][1], but each row in my spreadsheet has 24 columns. I would like to send… >>> More