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

=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"M INUTES",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,"M INUTES",TEXT(A5,"SS"),"SECONDS")

pls do rate

"F. Lawrence Kulchar" wrote:

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

=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"M INUTES",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

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

"F. Lawrence Kulchar" wrote in
message ...
I am using the concatenate function to list a "string" of elapsed time as
follows:

=CONCATENATE(A1,"YEARS",A2,"DAYS",A3,"HOURS",A4,"M INUTES",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