merge date/time value , concatenate ?

[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!

[arthurbr]

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]

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]

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

[oldchippy]

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

[okl]

Thanks, Solved!

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