| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate time from 3 columns
Hello So I have a report I imported and time is in 3 columns like this
10:00 - 10:30AM THe first and the third column are formated as time. what I need is the time to be in one column to look like this 10:00-10:30AM I tried to concatenate the 3 columns but then I loose the time format, I also tried = column a+column b+ column c and I get #Value. How can I do this? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate time from 3 columns
=TEXT(A1,"hh:mm") & "-" & TEXT(C1,"hh:mm AM/PM")
-- Gary''s Student - gsnu200732 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate time from 3 columns
=TEXT(I12,"hh:mm")&"-"&TEXT(K12,"hh:mm am/pm")
-- Don Guillett SalesAid Software "Wanna Learn" wrote in message ... Hello So I have a report I imported and time is in 3 columns like this 10:00 - 10:30AM THe first and the third column are formated as time. what I need is the time to be in one column to look like this 10:00-10:30AM I tried to concatenate the 3 columns but then I loose the time format, I also tried = column a+column b+ column c and I get #Value. How can I do this? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate time from 3 columns
Thank you - perfect....
"Gary''s Student" wrote: =TEXT(A1,"hh:mm") & "-" & TEXT(C1,"hh:mm AM/PM") -- Gary''s Student - gsnu200732 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| day and time concatenate | Excel Worksheet Functions | |||
| Is there a way to concatenate date and time? | Excel Discussion (Misc queries) | |||
| Concatenate two columns? | Excel Worksheet Functions | |||
| Concatenate/Time Functions | Excel Worksheet Functions | |||
| How to Concatenate Time with some operator? | Excel Worksheet Functions | |||
Linear Mode
