Go AD-Free with CAclubindia Pro and Daily Mobile Updates. Subscribe Now!

Combination of date & time

Excel 1273 views 2 replies

Rohit Bhalotia

52 Points Joined May 2008

Friends,

I have a data in which in one column date is given and in other column time is given. I need to combine both date & time in a single column in format DD:MM:YY H:MM

Kindly send me solution to this problem.

Replies (2)

Guest

425855 Points Joined August 2012

just simple

if a cell contains date & b cell contains time then next cell put the formula a+b and change the format of the cell as "dd/mm/yyyy hh:ss AM/PM"

Vishal

Account Assistant

45 Points Joined July 2008

if cell 'A1' contains date & cell 'B1' contains time then put the formula =concatenate(A1," ",B1) in any blank cell(i.e.equal to sign then type concatenate then opening bracket then A1 then comma then one space in double inverted comma or double quote then again comma and then B1 then complete the bracket)