Hi All -
I have two columns... timeStart and timeEnd. They contain the following values
timeStart = 1/1/1900 8:00 AM
timeEnd = 1/1/1900 5:00 PM
I need to cut the date out of the columns and combine the two of them into a new column called timeSpan, which would return this...
8:00 AM - 5:00 PM
I tried this....
timeStart + '-' + timeEnd As timeSpan
... but it doesn't work. Can someone show me how I can get the result I'm looking for.