I have 3000 lines of data that was imported from another database and appears as follows:
<tbody>
</tbody>
I need this to be hour: minute am/pm. Formatting does not work.
I assume it needs to be one of those “text” formulas. Can someone suggest how to write this or perhaps some other type of formula.
Cheers!
7:23PM |
12:34PM |
7:38PM |
10:39PM |
7:23PM |
12:45PM |
<tbody>
</tbody>
I need this to be hour: minute am/pm. Formatting does not work.
I assume it needs to be one of those “text” formulas. Can someone suggest how to write this or perhaps some other type of formula.
Cheers!