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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONCATENATE
=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 |
Reply |
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 |