CONCATENATE

[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

 

[Guest]

use text command:

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

pls do rate

 

[Bob Phillips]

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