Format times to display with 'AM/PM'

google-sheets google-docs time-format
Codeformer picture Codeformer · Aug 17, 2013 · Viewed 12.1k times · Source

Google Spreadsheet

Normally, when I enter times in Google spreadsheet as 22:00:00 the display automatically switches to 10:00 PMbut sometimes it's not converting.

How can I set a common format for times in Google spreadsheet? I need this format: 8:00 PM.

Answer

pnuts picture pnuts · Aug 17, 2013

Select all ranges that you wish to have this time format and go to Format > Number > More formats to select the one of your choice. (I think the one you want is near the bottom and shows as 3:59 PM.)

Related questions

Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet

I have several columns in Google Spreadsheet. I would like to count how many cells have a value (number or string) and display that number at the top of the column. For example: Hello World 123 Some string The above column …

Read More
How to define global variable in Google Apps Script

I see most examples from Google is they use only functions in a single giant script. e.g. https://developers.google.com/apps-script/quickstart/macros But in our style, we usually write all functions under a single namespace, such as …

Read More
Axis scale in google charts (from google spreadsheets)

I've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1 ,2 ,3 ,4 ,5 ,10 ,20 ,30 ,40 ,50 ,100 ,200 ,300 ,400 ,500 ,600 ,700 ,800 ,900 ,1000. Chart interprets them as a labels, not a number: So the distance between 1 and 4 is the same as between 20 and 50. How to change it? (Maybe …

Read More