Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Microsoft Windows › Excel string date & time to excel date time format
jimbob79

673 posts

Ultimate Geek
+1 received by user: 165


#210456 28-Mar-2017 11:58
Send private message

I have an excel file which has a column of dates and times. How do I convert this to excel datatime format?

 

 

 

 

26/03/2017 1:00

 

 

 

26/03/2017 2:00

 

 

 

26/03/2017 3:00

 

 

 

26/03/2017 4:00

 

 

 

26/03/2017 5:00

 

 

 

26/03/2017 6:00

 

 

 

26/03/2017 7:00

 

 

 

26/03/2017 8:00

 

 

 

26/03/2017 9:00

 

 

 

26/03/2017 10:00

 

 

 

26/03/2017 11:00

 

 

 

Create new topic
jamesrt
1663 posts

Uber Geek
+1 received by user: 941

ID Verified
Trusted
Lifetime subscriber

  #1749349 28-Mar-2017 12:49
Send private message

Are they not in datetime format already? (I ask because if I cut and paste those values from your post into a blank spreadsheet, Excel parses them correctly [and reformats slightly for display]; I know they are then "datetime" numbers as you can reformat back to "general" format and see the actual numbers [i.e. 42820.04167]).

 

If they are not, then perhaps if it's just a small amount of information, you could manually copy/paste into a new set of columns, Excel should "do it's thing", and then you could move (cut/paste) the new entries over the top of the old ones?

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.








RSS feeds
Main feed
Forums feed
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright