how do i combine a date cell and a time cell in excel?

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

Guest

how do i combine the date(A1) and time(B1) to show up in one cell and have
the correct format (C1).

A1 B1 C1
5/25/05 13:00 5/25/05 13:00
 
Just add 'em up; in C1: =a1+b1, then format it appropriately (Edit >
Format, on the numbers tab select Date, and scroll down til you see some
formats that include both date and time).
 
=TEXT(A1,"m/d/yy ")&TEXT(B1,"hh:mm")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
that worked great, thanks

bpeltzer said:
Just add 'em up; in C1: =a1+b1, then format it appropriately (Edit >
Format, on the numbers tab select Date, and scroll down til you see some
formats that include both date and time).
Click to expand...
 
Back
Top