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

concatenate time from 3 columns
 

=TEXT(A1,"hh:mm") & "-" & TEXT(C1,"hh:mm AM/PM")

--
Gary''s Student - gsnu200732

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

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