Hi all, I need help.
I have two columns I need to combine.
K2 M2
6:15 and 14:30
In another column I need K2 and M2 to read as
6:15 - 14:30
I can combine the two using...
=CONCATENATE(K21," - ",M21)
but I get the result...
0.197916666666667 - 0.458333333333333
and I cannot format the cell to read...
6:15 - 14:30
any suggestions?
Bookmarks