Combination of date & time

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)

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"

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)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details