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
834 posts

Ultimate Geek
+1 received by user: 289


  # 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 »

Dunedin selects Telensa to deliver smart street lighting for 15,000 LEDs
Posted 18-Jul-2019 10:21

Sprint announces a connected wallet card with built-in IoT support
Posted 18-Jul-2019 08:36

Educational tool developed at Otago makes international launch
Posted 17-Jul-2019 21:57

Symantec introduces cloud access security solution
Posted 17-Jul-2019 21:48

New Zealand government unveils new digital service to make business easier
Posted 16-Jul-2019 17:35

Scientists unveil image of quantum entanglement
Posted 13-Jul-2019 06:00

Hackers to be challenged at University of Waikato
Posted 12-Jul-2019 21:34

OPPO Reno Z now available in New Zealand
Posted 12-Jul-2019 21:28

Sony introduces WF-1000XM3 wireless headphones with noise cancellation
Posted 8-Jul-2019 16:56

Xero announces new smarter tools, push into the North American market
Posted 19-Jun-2019 17:20

New report by Unisys shows New Zealanders want action by social platform companies and police to monitor social media sites
Posted 19-Jun-2019 17:09

ASB adds Google Pay option to contactless payments
Posted 19-Jun-2019 17:05

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

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.