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

656 posts

Ultimate Geek
+1 received by user: 163

# 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
832 posts

Ultimate Geek
+1 received by user: 288


  # 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

Twitter and LinkedIn »

Follow us to receive Twitter updates when new discussions are posted in our forums:

Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:

Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:

News »

New Zealand PC Market declines on the back of high channel inventory, IDC reports
Posted 18-Jun-2019 17:35

Air New Zealand uses drones to inspect aircraft
Posted 17-Jun-2019 15:39

TCL Electronics launches its first-ever 8K TV
Posted 17-Jun-2019 15:18

E-scooter share scheme launches in Wellington
Posted 17-Jun-2019 12:34

Anyone can broadcast with Kordia Pop Up TV
Posted 13-Jun-2019 10:51

Volvo and Uber present production vehicle ready for self-driving
Posted 13-Jun-2019 10:47

100,000 customers connected to fibre broadband network through Enable
Posted 13-Jun-2019 10:35

5G uptake even faster than expected
Posted 12-Jun-2019 10:01

Xbox showcases 60 anticipated games
Posted 10-Jun-2019 20:24

Trend Micro Turns Public Hotspots into Secure Networks with WiFi Protection for Mobile Devices
Posted 5-Jun-2019 13:24

Bold UK spinoff for beauty software company Flossie
Posted 2-Jun-2019 14:10

Amazon Introduces Echo Show 5
Posted 1-Jun-2019 15:32

Epson launches new 4K Pro-UHD projector technology
Posted 1-Jun-2019 15:26

Lenovo and Qualcomm unveil first 5G PC called Project Limitless
Posted 28-May-2019 20:23

Intel introduces new 10th Gen Intel Core Processors and Project Athena
Posted 28-May-2019 19:28

Geekzone Live »

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

Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron

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.

Alternatively, you can receive a daily email with Geekzone updates.