12-hour or 24-hour time in exported text messages: what to choose
Messages on the iPhone shows time in your phone's format, but an export is a document, so check the preview to see how times are written and convert them in the CSV if the reader needs the other style. Whichever style you use, the same instant should have the same meaning: always check a.m. versus p.m. around noon and midnight.
Why format matters
- Court clerks, lawyers and HR staff may expect one format.
- 12-hour times are easy to misread without a.m. or p.m.
- 24-hour times are clearer in logs and abroad.
Getting the format you want
- Look at the preview in TextExhibit to see how times are written in the PDF.
- If you need another style, export the CSV, which holds the full date and time.
- In Excel, Numbers or Sheets, format the time column: Format Cells, Time, and pick 24-hour or 12-hour.
- Keep the original PDF as it is and say how you derived any reformatted version.
Ask what is wanted
Few places require one style. If a form or a lawyer has asked for a particular format, they should say so; ask them before reformatting. Reformatted times in a table should always be paired with the original export so they can be checked.
Converting in a spreadsheet, step by step
In Numbers, select the time column, open the Format sidebar, choose Date and Time, then pick the time format you want. In Excel, select the column, press Control-1, choose Custom and type hh:mm:ss for 24-hour time or h:mm:ss AM/PM for 12-hour time. In Google Sheets, use Format, Number, Custom date and time. If the column came in as text rather than a date, the format will not change; use the Text to Columns or DATEVALUE functions to turn it into real dates first.
What to keep in mind
- A reformatted spreadsheet is a derived copy and not the original record.
- Excel may change how a date is displayed on open. See exporting to Excel.
Questions
Does the iPhone setting for 24-hour time affect the export?
Check the preview; do not assume.
Which is better for a court document?
Ask the lawyer or clerk. Either is clear if a.m. and p.m. are marked.
Can I mix formats?
It is better not to.
Why will the format not change in Excel?
The column is probably text. Convert it to a real date and time first.
Does this change the PDF?
No. Only your spreadsheet copy.
Export the whole conversation
TextExhibit turns a conversation into one PDF with exact times, names and numbers, photos in place and page numbers, on your Mac. Free to preview; $24.99 once to export.