CODEWITHSUNDEEP
exceldatetext
Matthew Foody
Matthew Foody

Reputation: 25

Construct Excel Date and Hour

I have a date in text form that excel is not recognizing as a date and hour like i want it to. Is there a formula to break down this text and then build it back up as the correct date and time?

01.01.2012 08:00:00.000

Upvotes: 0

Views: 64

Answers (1)

Nick Perkins
Nick Perkins

Reputation: 1327

=DATE(MID(C5,7,4),MID(C5,4,2),LEFT(C5,2)) + TIME(MID(C5,12,2),MID(C5,15,2),MID(C5,18,2))

When the date string is in cell C5

Upvotes: 1

Related Questions