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