merge date/time value , concatenate ?

**okl** · 09-03-2008, 06:56 AM

Hi ,

how can i merge Date 1 and Time 1 into a cell ?
And give me mm/dd/yyyy hh:mm format?

And then a subtraction on 9/3/2008 0:00:40 - 9/2/2008 23:31:25, which give me a hh:mm:ss result?

Thanks!

**arthurbr** · 09-03-2008, 07:01 AM

Originally Posted by okl

Date 1 Time 1 Date 2 Time 2
9/2/2008 22:51:16 9/2/2008 23:31:25
9/3/2008 0:00:40 9/3/2008 0:37:58

Hi ,

how can i merge Date 1 and Time 1 into a cell ?
And give me mm/dd/yyyy hh:mm format?

And then a subtraction on 9/3/2008 0:00:40 - 9/2/2008 23:31:25, which give me a hh:mm:ss result?

Thanks!

Hi
just add Date1 and Time1 and format as needed ( right click the result cell, select Format Celle and select the needed format)
To substract, substract as usual and format the same way
Cheers

( and why add an image if you need a spreadsheet? :-))

**okl** · 09-03-2008, 07:06 AM

Originally Posted by arthurbr

Hi
just add Date1 and Time1 and format as needed ( right click the result cell, select Format Celle and select the needed format)
To substract, substract as usual and format the same way
Cheers

( and why add an image if you need a spreadsheet? :-))

Hi,

There are many rows, how can i convert all with mouse drag.
Instead copy 1 by 1?

Ok i tried to do =D1&E1 in the result cell, but resulted value is "396940.182766203703704"
instead of the m/d/yyyy hh:mm:ss format

**arthurbr** · 09-03-2008, 07:09 AM

Supposing Dates are in col A and times in col B in CI enter
=a1+b1
Enter
select C1
Double-click the handle at the lower right corner
Done

**okl** · 09-03-2008, 07:15 AM

Thanks, Solved!

Sometimes have to think in a simpler way to solve problem not really have to be complicated.

**oldchippy** · 09-03-2008, 07:15 AM

Originally Posted by okl

Hi ,

how can i merge Date 1 and Time 1 into a cell ?
And give me mm/dd/yyyy hh:mm format?

And then a subtraction on 9/3/2008 0:00:40 - 9/2/2008 23:31:25, which give me a hh:mm:ss result?

Thanks!

Try this

=(C1+D1)-(A1+B1) format cell to TIME