Seperating time from text
Solved/Closed
luigidelmonte
Posts
18
Registration date
Sunday 18 August 2019
Status
Member
Last seen
24 January 2020
-
23 Nov 2019 à 14:24
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2019 à 11:42
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 25 Nov 2019 à 11:42
Related:
- Seperating time from text
- Popcorn time apk - Download - Movies, series and TV
- Ocarina of time n64 rom - Download - Action and adventure
- Ps3 controller charging time - Guide
- Facebook account review time - Guide
- Time resolution download - Download - Gaming tools
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
25 Nov 2019 à 11:42
25 Nov 2019 à 11:42
Hi Luigi,
The formula below will extract the last 5 character of the text string of column H. The extracted string is changed into time format, so you can apply any time format you want. When the extracted string is not a time, then the destination cell is left blank.
Here is the formula:
=IF(ISERROR(TIME(LEFT(RIGHT(H2,5),2),RIGHT(RIGHT(H2,5),2),)),"",TIME(LEFT(RIGHT(H2,5),2),RIGHT(RIGHT(H2,5),2),))
Best regards,
Trowa
The formula below will extract the last 5 character of the text string of column H. The extracted string is changed into time format, so you can apply any time format you want. When the extracted string is not a time, then the destination cell is left blank.
Here is the formula:
=IF(ISERROR(TIME(LEFT(RIGHT(H2,5),2),RIGHT(RIGHT(H2,5),2),)),"",TIME(LEFT(RIGHT(H2,5),2),RIGHT(RIGHT(H2,5),2),))
Best regards,
Trowa
