CONCATENATE

  • Thread starter F. Lawrence Kulchar
  • Start date
F

F. Lawrence Kulchar

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
 
M

Muhammed Rafeek M

use text command:

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

pls do rate
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top