CONCATENATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the concatenate function to list a "string" of elapsed time as
follows:

=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"MINUTES",A5,"SECONDS")


The problem is as follows:

I get a rewsult such as:

5 Years 255 DAYS 22 HOURS 58 MINUTES 43.000501256 SECONDS

In other words, my seconds do not format properly eventhough cell A5 is
formatted correctly.

How is this fixed??

Thanks,

FLKulchar
 
use text command:

ex:
=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"MINUTES",TEXT(A5,"SS"),"SECONDS")

pls do rate
 
=A1&" Years "&A2&" Days "&A3&" Hours "&A4&" Minutes "&TEXT(A5,"00
""Seconds""")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top