Combining date and time into one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?

Thanks.
 
Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
describe.
 
=TEXT(A1,"m/dd/yy ")&TEXT(B1,"hh:mm")

is one way

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Myrna - I found your solution very helpful! Much better than the combining
text. It maintained the format and I was able to perform other functions on
the result.
Thank you!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the amount of time over a permitted amount (12 hours) 7
Can't graph data with Date Format with hours 2
Date Stamp with protection 6
Date Time formatting problem 7
How to customize =Now() 11
need formulae 11
If formula - URGENT 7
How do I delete merged cells in Excel without deleting the final d 5

Back
Top