Adding Hours to Date + Time Text Data

[ExcelQuestFL]

Hello,

Working with time in Excel can be a killer sometimes! ANY and ALL assistance would be so much appreciated

I have data that is text and includes a date and time. I want to add 5 hours to the time, and if it rolls to the following day, then I want that day included.

Currently, I use text to columns and have 1 column with a numerical Date, and 1 column with a text Time. I use a formula to add 5 hours to the time, but if I roll to the following day, I have no idea it happened.

This is what my original data looks like - 08/12/2012 22:07:09:328
And this is the formula I use to add 5 hours after the text to column - =TIME(MID(C3,1,2),MID(C3,4,2),MID(C3,7,2))+TIME(5,0,0)

My desired result is to have 1 Column with the new date if it happened and 1 Column with the time 5 hours ahead. I've attached a sample of what the data looks like with desired result if rolling to a new day - T +5.xlsx

I think this will be a breeze for some of you, but I've literally spent hours trying different approaches and the above is the closest I've gotten

EDIT - Or I would be open to keeping the date and time stamp in 1 one cell, adding the 5 hours and then splitting it out. But I'm not sure how to do that..