Related:
- Seperating time from text
- Facebook posts can't be loaded at this time ✓ - Forum - Facebook
- The connection has timed out ✓ - Forum - Firefox
- Whatsapp you have guessed too many times ✓ - Forum - WhatsApp
- This is because you tried to do something too many times. please try again later. ✓ - Forum - Facebook
- Keyboard typing letters and numbers at the same time ✓ - Forum - Windows
1 reply
TrowaD
- Posts
- 2691
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 14, 2021
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
Subscribe To Our Newsletter!
