Changing time from 24h to 12h

[Nicole H]

I have a Google sheet with about 15-20 sheets and when I import the data daily it automatically comes across in 24h format. Is there an app script or a simplistic way to change every sheet to 12h format? If it matters or if it makes it easier it’s row 3 down to last row , and only columns D & L.

Any assistance or pointing me to the right direction would be appreciated

[Bennett, Scott]

You could change the date format in the columns.  Or you can use setNumberFormat() in Apps script.

On Thu, Jan 28, 2021 at 9:07 AM Nicole H <lucky...@gmail.com> wrote:

I have a Google sheet with about 15-20 sheets and when I import the data daily it automatically comes across in 24h format. Is there an app script or a simplistic way to change every sheet to 12h format? If it matters or if it makes it easier it’s row 3 down to last row , and only columns D & L.

Any assistance or pointing me to the right direction would be appreciated

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/40666d12-adb5-4d20-9d17-c58f194c5ca4o%40googlegroups.com.

--

Scott Bennett

Data and Assessment Coordinator/Math Teacher

Bradley-Bourbonnais Community High School

P 815.937.3707 ext. 6010

C 708.584.0872

[Ed Sambuco]

Your question is a bit more complicated than you might think,

It depends on the format of the date in the spreadheets you get.

If the input date cellls are formatted as strings, your best option is to fashion the strings so  that you can construct a date object out of it in app script.

Since you apparently want a timestamp value rather than just a date (format DateTime), then the data should already be a date object in the cells.

Either way, you need to start out with a date object.  Retrieve the cell(s) with getValue()  NOT getDisplayValue(), and then stringify it to whatever format you want with Utilities.formatDate().

[Ed Sambuco]

Actually, ther is a way to do this within the sheet ... go to Format ==.> Number ==> More options == More date and time options,  You can then edit as needed.

On Thursday, January 28, 2021 at 10:06:57 AM UTC-5, Nicole H wrote: