Forum Discussion
Combing date and time from two different cells into third cell
I am trying to combing a date from one column and a time from a second column into a third cell on another column. I've tried to Combine data with the ampersand symbol AND Combine the data using th...
If you format that cell using one of the custom formats you'll see the date and time
| 12/6/13 3:00 PM |
| 443380.625 |
Same cell, different formatting. In other words, your connecting them worked both times.