Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Help | Excel Discussion (Misc queries) | |||
Concatenate help | Excel Worksheet Functions | |||
Concatenate | Excel Worksheet Functions | |||
Concatenate | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |