Discussion Groups Home

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

12/6/2005 2:50 PM PST

Question

	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

Was this post helpful to you?

Top

bpeltzer

12/6/2005 3:03 PM PST

Answer

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

Was this post helpful to you?

Top

Season

12/6/2005 3:08 PM PST

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

Was this post helpful to you?

Top

Bob Phillips

12/6/2005 3:07 PM PST

	=TEXT(A1,"m/d/yy ")&TEXT(B1,"hh:mm") -- HTH RP (remove nothere from the email address if mailing direct) "Season" <Season@discussions.microsoft.com> wrote in message news:9FA595E5-7660-49EE-AAB6-009DF6F2D848@microsoft.com... > 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 > >

Was this post helpful to you?

Top

	Return to Microsoft Communities		Notify me of replies