How to Show Regular Time in Google Spreadsheets
Tuesday, September 18th, 2007I cannot read military time. I can read regular time. Google Spreadsheets at the time of this writing only supports formatting for military time. After digging around, I found this formula works:
=TEXT ( theCell, “hh:mm a”)
You can then have the military time column (which will auto-format when you type a time value […]
RSS Feed