Thread: Macro or formula on Excel to Standardize dates
View Single Post
 
Old 02-13-2017, 05:46 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
Actually, now that I think about it, you can use Int and Mod to separate the date and time.

See if this attachment helps
Attached Files
File Type: xlsx Leonardo.xlsx (8.7 KB, 9 views)
Reply With Quote