New answers tagged


Install this add-in from Google Web Store into Google Chrome: CloudCodes Insertable -


It's not possible without a formula. Separate time storing from time displaying by using one cell to store the time and another to display it in the desired format by using a formula like the following =HOUR(A1)&":"&TEXT(MINUTE(A1),"00")


Good question: I just looked expecting to find an option under Format > Number > More Formats > Custom Number Format but couldn't see anything that would work. If you do end up doing it with a formula, then the easiest approach may be to use helper columns, and something like =if(hour(E6) > 12, hour(E6)-12, hour(E6)) (Not the answer you want, I know, ...


I realise that this question is almost 5 years old, but since the problem still persists in Google Docs, I'll share the solution that works for me. Your best bet is to use the “print” feature within the Chrome browser. Rather than exporting to a .pdf within Google Docs, click on the menu button in Chrome and select print. Change the destination to “save as ...

Top 50 recent answers are included