Seperating time from text
Solved/Closed
luigidelmonte
Posts
18
Registration date
Sunday August 18, 2019
Status
Member
Last seen
January 24, 2020
-
Nov 23, 2019 at 02:24 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2019 at 11:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 25, 2019 at 11:42 AM
Related:
- Seperating time from text
- Popcorn time download - Download - Movies, series and TV
- Ocarina of time rom - Download - Action and adventure
- Whatsapp time setting - Guide
- Summer time saga - Download - Adult games
- Time of day clock stopped - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 25, 2019 at 11:42 AM
Nov 25, 2019 at 11:42 AM
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
