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

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
 
G

Guest

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

Guest

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

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

[NEWBIE] date/time diff 4
Combining a whole number and a % in one cell 1
Date time problem 1
Date converts to number when part of a formula 3
Time Calculations Help 4
Time calculation problem (URGENT>>>Project due) 4
EXCEL FORMULA 2
formula to display cell address 2

Top