ConvertMilitaryTime
Menu

24-hour ↔ 12-hour clock

Batch Military Time Converter — Convert a Whole List

Paste a list of times and convert every line at once — military to 12-hour and back. Your notes stay on their line, then copy or download the table as CSV.

Any mix works: 0700, 07:00 or 7:00 AM. Words on the line stay as a note.

Rows converted

0

Paste times on the left to start.

Paste a list into the box above — next week's rota, a timesheet column, a dispatch log — and every line comes back converted in one pass. Each row gives the four-digit military time, the same moment on the 12-hour clock, and how it would be said out loud, while whatever words you wrote on the line stay as a note against that row.

The converter reads 0700, 07:00 and 7:00 AM in the same list, so a sheet that mixes conventions does not have to be cleaned up first. Nothing is uploaded: the whole list is processed inside your browser as you paste.

How to convert a list of times

  1. Paste one time per line. A column copied out of Excel, Google Sheets or a PDF usually arrives that way already, one value per line.
  2. Add a note after the time if you need one. Night shift 1930 keeps "Night shift" in the first column; the converter takes the time it finds on the line and leaves the rest alone.
  3. Read the table. Four-digit military time, the same moment as AM/PM, and the spoken form used on a radio.
  4. Copy or download. Copy results gives tab-separated text that drops straight back into a spreadsheet; Download CSV saves military-time-list.csv with a note, military, 12-hour and spoken column.

What a batch converter is for

A single converter answers "what is 2130?" A list answers a different question: what are these twenty times? That is the shape most real schedules arrive in.

  • Rotas and shift schedules — a week of start and finish times is a list before it is anything else.
  • Timesheets and payroll — hours are written on the 24-hour clock, then typed into a system that wants decimal hours. The hours calculator does that subtraction shift by shift.
  • Dispatch and transport logs — pickup and arrival columns, usually written by several people in several formats.
  • Handover sheets on a ward — medication and observation times, where a misread reading is not a small mistake.
  • Radio traffic — the spoken column is the form you actually say, not the form you write.

Formats it reads

What you paste What it is read as
0700 07:00 → 7:00 AM
1930 19:30 → 7:30 PM
07:00 7:00 AM
23:45 11:45 PM
7:00 AM 0700
7pm 1900
9:45 PM 2145
930 09:30 → 9:30 AM

One thing it cannot guess: a bare number with no minutes is read as an hour. 7 becomes 0700, and 19 becomes 1900.

The leading-zero trap in Excel

This is the complaint that brings most people to a batch converter in the first place. You type 0700 into a cell, press Enter, and Excel shows 700. Nothing was converted wrongly — a spreadsheet stores a number, and a number has no leading zero.

Two fixes, in order of preference: format the column as Text before pasting, or type an apostrophe before the digits ('0700). If the zeros are already gone, 700 still converts to 07:00 here, because the digits before the last two are read as hours and the last two as minutes.

Both directions in one pass

Because each line is read on its own, a list can mix 1930 with 7:45 PM and both come back correct. That happens whenever a column has been part-written by day staff and part by whoever runs the evening board, and it saves you splitting the sheet before converting it.

If a line cannot be read as a time at all, it is listed under the table as not recognised rather than silently dropped — you can see which rows need fixing instead of counting rows and wondering where one went.

What this page does not do

  • It converts clock times, not spans. For "clock in 2300, clock out 0715" use the hours calculator, which counts the overnight shift instead of treating 0715 as earlier than 2300.
  • It reads one time per line. A line holding a start and a finish gets read as the first one only; put them on separate lines.
  • It does not add dates. A list of clock times has no day attached, so 00:30 is always the start of a day on its own row.

Free to use, and the list stays on your device

Last reviewed November 2026.

  • No daily limit. Convert as many lists as you like. The only cap is 500 lines per paste, announced when you reach it.
  • No account, no email, no payment. The converter works the moment the page loads.
  • Your list is not uploaded. The conversion and the CSV file are produced by the page itself with JavaScript; the times and notes you paste are not submitted to a server and we do not store them.
  • No install. It runs in a phone, tablet or desktop browser.

Related pages

  • The military time chart lists every hour and quarter hour with the 12-hour equivalent if you would rather look a value up than paste a list.
  • The 24-hour time converter takes one time in the colon form and steps through a timetable hour by hour.
  • Ten conversion mistakes worth knowing before you trust a column of times are collected on the conversion mistakes page.

Frequently asked questions

Can I convert a whole list of military times at once?

Yes — paste one time per line, up to 500 lines. Each row returns the military time, the 12-hour reading and the spoken form.

What formats can I paste into the batch converter?

0700, 07:00 and 7:00 AM, mixed freely in the same list, because every line is read on its own.

Does it keep the notes I wrote next to each time?

Yes. "Night shift 1930" keeps "Night shift" in the note column against that row.

Is my list uploaded to a server?

No. The conversion and the CSV are produced in your browser; nothing you paste is sent to us or stored.

Can I download the converted list as a CSV file?

Yes — military-time-list.csv, with note, military, 12hour and spoken columns. Copy results gives the same table as tab-separated text.

Why did Excel turn 0700 into 700?

Because a spreadsheet stores a number and a number has no leading zero. Format the column as Text first, or type an apostrophe before the digits.

How many lines can it convert at once?

500 per paste. Longer lists stop at 500 with a visible warning, so nothing disappears without notice.

Can it convert 12-hour times to military time as well?

Yes, in the same pass. 7:45 PM becomes 1945 and 1945 becomes 7:45 PM in one list.

Does it work out shift length across midnight?

No — it converts clock times. For 2300 to 0715 use the hours calculator, which counts the overnight span.

Is the batch converter free with no daily limit?

Yes. No daily limit, no account, no payment, and no installation.