JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
One column of a table contains timestamps (date + time). Here is an example:
<tbody>
</tbody>
A5 is identical to A4 and both A7 & A8 are identical to A6. I would like to display the data in Col A as it is in Col B. Is that possible without changing the actual underlying values?
I would prefer not to have a second column just for the display, as above.
R/C | A | B |
1 | 8/04/18 08:10p | 8/04/18 08:10p |
2 | 8/05/18 06:47p | 8/05/18 06:47p |
3 | 8/06/18 07:35a | 8/06/18 07:35a |
4 | 8/06/18 06:03p | 8/06/18 06:03p |
5 | 8/06/18 06:03p | = |
6 | 8/07/18 06:55p | 8/07/18 06:55p |
7 | 8/07/18 06:55p | = |
8 | 8/07/18 06:55p | = |
9 | 8/08/18 08:46a | 8/08/18 08:46a |
10 | 8/09/18 09:30a | 8/09/18 09:30a |
<tbody>
</tbody>
A5 is identical to A4 and both A7 & A8 are identical to A6. I would like to display the data in Col A as it is in Col B. Is that possible without changing the actual underlying values?
I would prefer not to have a second column just for the display, as above.