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