dslreports logo
 
    All Forums Hot Topics Gallery
spc
uniqs
287
batsona
Maryland
join:2004-04-17
Ellicott City, MD

batsona

Member

[Excel] Combining cells in Excel...

How do I get Excel to combine the two fields shown, so that, for example, "3:45:33 PM" appears? Nothing works. I have column D formatted for 'time', and it still comes out a mess of decimals..... You'd think this would be easy, but it doesn't seem to be. I'm using Office 2007.

Kalford
Seems To Be An Rtfm Problem.
MVM
join:2001-03-20
Ontario

1 edit

Kalford

MVM

put this formula in cell D1 and copy down accordingly. Format the cells to time format.

=IF(C1="PM",B1+0.5,B1)


H2OuUp2
Happy to be here
Premium Member
join:2002-03-15
Oklahoma City, OK

H2OuUp2 to batsona

Premium Member

to batsona
Are you putting a time in both cells? Excel will add times, but the decimal you have in column "D" is 7:04:24 AM. You cannot add it to column "B" and ever get 3:45:33 PM without a multiplier.

Explain better what you are tying to accomplish. It's easier to enter in military time and format in AM/PM. You then enter 15:33 to get 3:15PM

More details or an example would help in solving your problem.
dmagerl
Premium Member
join:2007-08-06
Woodstock, IL

dmagerl to batsona

Premium Member

to batsona
=TEXT(B1,"hh:mm:ss")&" "&C1
Time is not a text string so it has to be converted to text first.