welcome 123
asked on
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?
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi Barry, How ru doing buddy..?
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)
then formula to concatenate all three is as follows:
=TEXT(A2,"mm/dd/yyyy" )&" "& RIGHT("00" & B2,2) & ":" & RIGHT("00" & C2,2)
Welcome back, Saurabh!
ASKER
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
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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..