Related:
- Seperating time from text
- Post cannot be loaded at this time ✓ - Forum - Facebook
- Aol network connection timed out ✓ - Forum - WiFi
- 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
- The connection has timed out ✓ - Forum - Firefox
1 reply
TrowaD
- Posts
- 2669
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 15, 2020
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
