Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2020, 07:46 PM
Alaska1 Alaska1 is offline Parse Date and Time Field into two columns Windows 7 64bit Parse Date and Time Field into two columns Office 2007
Advanced Beginner
Parse Date and Time Field into two columns
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default 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
File Type: xlsx Book1.xlsx (8.4 KB, 8 views)
Reply With Quote
  #2  
Old 02-04-2020, 12:40 AM
ArviLaanemets ArviLaanemets is offline Parse Date and Time Field into two columns Windows 8 Parse Date and Time Field into two columns Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

It's OK? :-)
Attached Files
File Type: xlsx TruncDate.xlsx (10.1 KB, 7 views)
Reply With Quote
  #3  
Old 02-04-2020, 04:40 AM
Alaska1 Alaska1 is offline Parse Date and Time Field into two columns Windows 7 64bit Parse Date and Time Field into two columns Office 2007
Advanced Beginner
Parse Date and Time Field into two columns
 
Join Date: Nov 2011
Posts: 96
Alaska1 is on a distinguished road
Default

Thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


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 Date and Time Field into two columns Parse data in one column to 3 other columns texascpa Excel 4 02-20-2017 04:53 AM
Parse Date and Time Field into two columns 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
Parse Date and Time Field into two columns 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 02:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft