combing multiple cell data into one cell (show string of data in one cell)

**EvenRtrsUsExcel** · 05-12-2013, 08:23 PM

Hi all. New to the forum. I did a quick search and although I'm sure this question has been answered at some point in time, it wasn't in the top results that showed up.

Anyway, I have a column of hours and another column of minutes. It's and complicated story as to how the data ended up getting represented this way instead of hours and minutes together in the first place.

So I want another column that shows the hours and minutes together so that I can use that data to calculate dates progressed from the progression of time. (The times are all in ascending order).

- DB

**benishiryo** · 05-12-2013, 08:30 PM

hi DB, welcome to the forum. depends on what your data in column A & B are showing. is it:
a) 2:00 and 0:34 or;
b) 2 and 34

for a), just:
=A1+B1

for b), try:
=TIME(A1,B1,)

**EvenRtrsUsExcel** · 05-13-2013, 11:39 AM

Thanks a lot.

Now to add to that.

If another cell had the date and I wanted to combine the date with the time into one cell?

**EvenRtrsUsExcel** · 05-13-2013, 11:40 AM

Originally Posted by benishiryo

hi DB, welcome to the forum. depends on what your data in column A & B are showing. is it:
a) 2:00 and 0:34 or;
b) 2 and 34

for a), just:
=A1+B1

for b), try:
=TIME(A1,B1,)

Thanks a lot.

Now to add to that.

If another cell had the date and I wanted to combine the date with the time into one cell?

**benishiryo** · 05-13-2013, 09:00 PM

you're welcome. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

Excel recognises dates as integers & time as decimals. to verify, type in 1jan2013 in A1. and 12 pm in B1. Format both cells to General. you will see that A1 is 41275 (meaning 41,275th day from 1 Jan 1900) & B1 is 0.5 (1/2 a day).*so you can simply add them together. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.