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