Simple question regarding formatting a cell with a formula

  • Thread starter Thread starter scottnshelly
  • Start date Start date
S

scottnshelly

hey guys,
i have a formula that looks similar to: =CONCATENATE(A1,B1,C1,D1,E1,F1
which as you know adds the contents of these cells into one cell. cell
c1 and e1 are numbers in time format (i.e. 17:00). when i put in th
formula it reads those numbers in text format or something and the
come out as decimals. my question is: how do i get the formatting t
time. i've tried changing the formatting by going to format > cells
but no soup.
thanks
 
Hi Scott!

Use:

=TEXT(A1,"hh:mm:ss")&" "&TEXT(B1,"hh:mm:ss")

Or the same in CONCATENATE

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks Dave,
I did it and i got 0:000:00. i don't want to sound as ignorant as
am, but what did i do wrong to cuase this
 
What did you have in A1:F1?

If those cells were empty, I'd get the same thing:

=A1&B1&TEXT(C1,"h:mm")&D1&TEXT(E1,"h:mm")&F1

could be changed to:
=A1&B1&if(c1="","",TEXT(C1,"h:mm"))&D1&if(e1="","",TEXT(E1,"h:mm"))&F1

And the empty times cells could be suppressed.
 
Back
Top