Combine Date field from 2 seperate fields

Hello I have 3 columns in Excel where one had Date in the format mm\dd\yy and 2nd column is Hour and third column is MInutes and I want to have a column which will combine all thses three values in the format mm\dd\yy hh:mm kindly help?
welcome 123Asked:
Who is Participating?
 
barry houdiniCommented:
If date is in A2, hours (as a number) in B2 and minutes (also as a number) in C2 then in D2 try

=A2+(B2+C2/60)/24

format D2 in required format

regards, barry

PS Hey Saurabh!
0
 
Saurabh Singh TeotiaCommented:

Use this formula assuming you have values in A1 as in date and time in b1..

=TEXT(a1,"mm/dd/yy") & " " & text(b1,"hh:mm")

Saurabh...
0
 
Saurabh Singh TeotiaCommented:

Alternatively you can also do this...

=a1+b1

and format the same as mm\dd\yy hh:mm by right click format cells-->custom and enter your format there..
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
barry houdiniCommented:
See example of the above

barry
27389135.xls
0
 
Saurabh Singh TeotiaCommented:


Hi Barry, How ru doing buddy..?
0
 
experts1Commented:
Assuming your 3 columns are A2(mm/dd/yy), B2(hh)  and C2(mm),
then formula to concatenate all three is as follows:

=TEXT(A2,"mm/dd/yyyy" )&" "& RIGHT("00" & B2,2) & ":" & RIGHT("00" & C2,2)

0
 
Patrick MatthewsCommented:
Welcome back, Saurabh!
0
 
welcome 123Author Commented:
Well I tried one which really worked well but did not ttu others but I always belive ingiving points to the first come solution, so will try them and then close and give points and the one i Tried and is working is from barryhoudini: =A2+(B2+C2/60)/24

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.