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

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

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

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

"Season" wrote:

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

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

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

--

HTH

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


"Season" wrote in message
...
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

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

that worked great, thanks

"bpeltzer" wrote:

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

"Season" wrote:

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