Date & Time Splitter — 2 Column Separator
Instantly split combined date and time strings into separate Date and Time columns. Supports single strings, bulk logs up to 5,000 lines, and CSV column splitting.
Formatting & Parser Controls
Enter Single Date-Time String
100% Client-Side Privacy Protection
All date and time splitting is performed locally inside your web browser. No dates, log files, user records, or spreadsheet data are ever transmitted to external servers.
How to Split Date and Time into Two Columns in Excel
If cell A2 contains 2024-12-31 14:30:00:
- Date Column:
=INT(A2)(Format cell as Date) - Time Column:
=MOD(A2, 1)(Format cell as Time)
Skip complex formulas and format adjustments:
- Paste your date-time column into the Bulk List or CSV tab above.
- Select your desired Date and Time formats.
- Click Export CSV or Copy 2 Columns TSV to paste directly into Excel!
Frequently Asked Questions (FAQ)
Related ToolsData
Discover other free online tools to boost your productivity
Text Splitter & Columns Converter
Split multi-delimiter records into structured table columns (Excel-like Text to Columns) or chunk documents by characters, words, or lines. Full support for English and Khmer Unicode text with clean CSV/Excel exports.
CSV Cleaner & Formatter
Clean, format, and fix messy CSV or TSV files online. Trim whitespace, remove empty rows, deduplicate records, reformat casing per column, select/exclude columns, and export clean CSV or TSV files. 100% client-side.
Phone Number Cleaner Pro
Clean, validate, and standardize Cambodian phone numbers in bulk. Identify operators (Smart, Cellcard, Metfone, Seatel, Cootel), remove duplicates, convert Khmer digits, choose from 5 output formats, and export clean lists as CSV or TXT. 100% client-side.
Data Formatter
Format and convert CSV, TSV, TXT, or Excel tabular spreadsheet copy-pastes into other clean data layouts. Output structure-mapped SQL INSERT statements, beautified JSON arrays, Markdown documentation tables, or clean CSV sheets.
Save this tool to your Favorites
Sign in with Google to bookmark tools and access them quickly from your Favorites tab.
Help us improve this tool!
Found a bug, want a new option, or have suggestions for Khmer Unicode formatting? Share your comments and help us improve.
Discussion
0Join the discussion
Sign in to leave feedback, ask questions, or report bugs. Your input helps improve this tool!
No comments yet. Be the first to share your thoughts!