Skip to content

MM/DD/YYYY 24h to MM/DD/YYYY converter

US date-time (MM/DD/YYYY HH:mm:ss) → US date (MM/DD/YYYY)

MM/DD/YYYY · MM/DD/YYYY

06/29/2024

Worked examples

InstantMM/DD/YYYY 24hMM/DD/YYYY
an ordinary afternoon06/29/2026 14:30:0006/29/2026
a leap day02/29/2028 09:05:0702/29/2028
the Unix epoch01/01/1970 00:00:0001/01/1970

What this conversion changes

  • Dropped on the way out: hour, minutes, seconds. The conversion is lossy; converting back will not restore them.

MM/DD/YYYY 24h — US date-time (MM/DD/YYYY HH:mm:ss)

Pattern
MM/DD/YYYY HH:mm:ss
Example
06/29/2024 00:00:00
Seen in
Excel (US locale), Windows Event Viewer exports, US banking CSVs

MM/DD/YYYY — US date (MM/DD/YYYY)

Pattern
MM/DD/YYYY
Example
06/09/2024
Seen in
US business documents, Excel (US locale), Exports from US SaaS tools

Thousands of values to convert?

CSV batch mode converts an entire column from MM/DD/YYYY 24h to MM/DD/YYYY (or any of the 82 formats, with time-zone shifts), entirely in your browser, with no row limit set by us (your device's memory is the practical ceiling). $9.99/month, hides the ads, cancel anytime.