concatenate time from 3 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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