moramramesh
New Member
- Joined
- May 22, 2019
- Messages
- 17
I have timestamp under Column A in this format: 2019-06-27T16:05-0400. I want only 16:05 from that timestamp i.e. hh:mm. Can someone help how we can do using macro?
Source
<tbody>
</tbody>
Target:
<tbody>
</tbody>
Source
2019-06-27T16:05-0400 |
2019-06-27T16:10-0400 |
2019-06-27T16:35-0400 |
<tbody>
</tbody>
Target:
16:05 |
16:10 |
16:35 |
<tbody>
</tbody>