You paste a timetable into the booking system, hit import, and it bounces back — every time is in the wrong shape. The sheet you were given runs on 12-hour AM and PM, the system only takes 24-hour times, and now you’re facing a column of times that all need fixing before anything will load. This free tool is built for that exact moment: paste the whole list and use this 12 to 24 hour time converter in one pass, then copy the result straight back.
Bulk 12-Hour to 24-Hour Time List Converter
Paste your times, one per line. The tool converts the whole list at once and keeps your original order. Mix formats in one list — 3pm, 15:30, 3:30 PM, 3.30 PM and a bare hour like 3 (read as 3:00 AM) all work.
| Original | Converted |
|---|
How to use the 12 to 24 hour time converter
Paste your times into the box above, one per line, exactly as they appear in your sheet or log. It doesn’t matter if some lines have seconds and some don’t — the tool reads each line on its own, so a mixed list is fine.
Next, pick your direction. “12-hour to 24-hour” is the usual choice when a system wants 24-hour times, and “24-hour to 12-hour” is there for the trip back. Then pick your output style: HH:MM for most imports, HH:MM:SS if your system wants seconds, or military HHMM if it wants a plain four-digit time with no colon at all.
Press “Convert Times” and you’ll see two things: a paste-ready list you can copy in one go, and a table that lines each original time up next to its converted version. The notice above the result tells you how many times were converted, and any line the tool couldn’t read is flagged on its own, so you can fix just that line instead of hunting through the whole list.
The 12 AM and 12 PM traps
Most of the list is simple — add 12 to a PM hour and you’re done. The trouble starts at noon and midnight, and it’s the same trap every time. People see 12 and assume the rule still works, then end up with a timetable that’s 12 hours out.
Here’s the rule the tool follows, so you can trust it even when it looks odd: 12 AM is midnight, so it becomes 00. 12 PM is noon, so it stays 12. Every other PM hour adds 12, so 1 PM becomes 13 and 11 PM becomes 23, while every other AM hour stays as it is, with a leading zero where the system wants one — 8 AM becomes 08, not 8.
That matters more than it sounds. A rota that says 12:00 AM means the shift starts at midnight, not at noon, and a class that ends at 12:15 PM finishes just after lunch. Get either one wrong and the whole day slides. If you’re checking the result by eye, those two lines are the ones to look at first.
Output styles explained
HH:MM is the style most systems ask for, and it’s the default here. It’s short, clear, and it matches the way most timetables and booking screens show times. If your import is happy with 08:30, stop there.
HH:MM:SS adds seconds to every time. If a line already has seconds, they’re kept; if it doesn’t, the tool adds :00. That keeps every line the same length, which is what some logs and databases expect, and it stops a system from rejecting a line just because the seconds are missing.
Military HHMM drops the colon and gives you four digits, so 8:30 AM becomes 0830 and 11:45 PM becomes 2345. It’s the style you’ll see in transport schedules, some rota software, and older systems that only accept a plain number. Pick the style your receiving system wants before you convert, and if you’re not sure, try HH:MM first — you can always paste the same list back in and run it again in a different style.
Convert 12 hour time to 24 hour time in a list
Paste a list of times, one per line, and the converter returns each one in 24-hour form, in HH:MM, HH:MM:SS or military HHMM. Lines the converter cannot read are flagged per line instead of breaking the list.
| 12-hour time | 24-hour time |
|---|---|
| 12:00 AM | 00:00 |
| 1:00 AM | 01:00 |
| 6:00 AM | 06:00 |
| 11:00 AM | 11:00 |
| 12:00 PM | 12:00 |
| 1:00 PM | 13:00 |
| 6:00 PM | 18:00 |
| 11:00 PM | 23:00 |
Worked example: a list of times to 24-hour format
Take three times from a typical day: 8:30 AM, 12:15 PM and 11:45 PM. Paste them in, leave the direction on 12-hour to 24-hour, and press “Convert Times”. The notice reads “Converted 3 times.” and the table shows the change line by line.
8:30 AM is a morning time, so nothing is added — it just gets its leading zero and becomes 08:30. 12:15 PM is noon, so it stays 12:15; this is the line that catches people out, because adding 12 would give a nonsense 24:15. 11:45 PM is late evening, so 12 is added to the hour and it becomes 23:45.
Copy the converted list and paste it into your system. The order hasn’t changed, so each time still sits next to the same class, shift or booking it started with — only the shape of the time has changed.
Converting back again
Sometimes the flow runs the other way: a system exports a list in 24-hour time, and you need to send it to people who read 12-hour times. Switch the direction to “24-hour to 12-hour” and the tool works in reverse.
It takes 12 away from any PM hour and puts the AM or PM marker back on, so 23:45 becomes 11:45 PM and 08:30 becomes 8:30 AM. Midnight, 00:00, becomes 12:00 AM, and noon, 12:00, stays 12:00 PM. The same three output styles apply, so you can choose HH:MM for a readable list or HH:MM:SS if the people you’re sending it to need seconds.
That’s handy for printed rotas, parent letters, and anything else where a plain 14:30 would make someone stop and work it out. Run the export through the tool, copy the result, and the list is ready to share without a single row-by-row edit.
Related time tools
If your times need more than a format change, try the Work Hours to Decimal Time Converter when a timesheet wants hours as decimals, or the Laundry Timetable Planner when you need to plan wash and dry times around the rest of your day.
Frequently asked questions
Is 12 AM midnight or noon?
12 AM is midnight, the very start of the day, so it converts to 00:00, while 12 PM is noon, halfway through the day, so it stays 12:00. It’s the one pair worth double-checking, because swapping them moves a time by 12 hours.
Are seconds kept?
Yes, if a line has seconds, they’re carried through to the result, and if you pick the HH:MM:SS style, lines without seconds get :00 added so every line matches. If you pick HH:MM or HHMM, seconds are left out of the output.
What if a line has no AM/PM?
A line with no AM or PM is read as a 24-hour time, so 14:30 stays 14:30 in the 12-hour to 24-hour direction, and a four-digit line such as 0830 is read the same way. If you meant it as a 12-hour time, add AM or PM to the line and run it again.
Can I get military HHMM output?
Yes, pick “Military HHMM” from the output style list before you convert, and the tool will give you four digits with no colon, such as 0830 for 8:30 AM and 2345 for 11:45 PM. It’s the style to use when the system you’re pasting into only accepts a plain four-digit time.
How do I convert 12 hour time to 24 hour time in Excel?
In Excel, use =TEXT(A1,”HH:MM”) on a cell holding a 12-hour time, and it returns the 24-hour form. For a whole list, paste it into this converter instead and it returns every row at once, with a CSV download.
Can I convert a whole list of times at once?
Yes. Paste the times one per line and the converter returns each one in 24-hour form, in the output style you picked. You can download the converted list as a CSV, and any line it cannot read is flagged instead of stopping the rest.
Nothing is uploaded or stored while you use this tool — the conversion runs in your browser, so your times never leave your computer.