Parse Date and Time Field into two columns

		Microsoft Office Forums > Microsoft Excel > Excel
Parse Date and Time Field into two columns

02-03-2020, 07:46 PM

Alaska1

Windows 7 64bit Parse Date and Time Field into two columns

Office 2007

Competent Performer

Join Date: Nov 2011

Posts: 110

Parse Date and Time Field into two columns

In the attached document I need to parse the date and time field into two columns. What is the best formula to use?

Attached Files

Book1.xlsx (8.4 KB, 10 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OneNote on Android phone View Tags? Enter Date, Time, Date & Time	DrTwinkyEsq	OneNote	0	03-27-2017 07:54 PM
Parse data in one column to 3 other columns	texascpa	Excel	4	02-20-2017 04:53 AM
Parse date and time from one cell and paste it to another for all files in a folder?	chrisd2000	Excel Programming	3	07-03-2014 10:56 AM
Date field inserting merge date in blank field	Lesley	Mail Merge	5	09-30-2013 01:49 AM
Date/Time Field Autopopulation Question	Dendalee	Word	3	10-26-2012 06:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.