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

S

Season

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
 
B

bpeltzer

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).
 
B

Bob Phillips

=TEXT(A1,"m/d/yy ")&TEXT(B1,"hh:mm")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

Season

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...
 
Top