AYouQueTai
New Member
- Joined
- Sep 14, 2019
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
Hello,
Wondering how you all would go about this. I have been mucking around with this all afternoon trying to go from LEFT to RIGHT and using LEN to come up with a formula that works for all of the following entries.
How would you standardize this? There are no seconds when there are hours. the minutes go from left to right depending on if there are hours. If there are 1-9 units it is a single digit rather than always having 2, so it moves the hour, minute or second identifier. Is there an easy way to do this?
Thanks,
Wondering how you all would go about this. I have been mucking around with this all afternoon trying to go from LEFT to RIGHT and using LEN to come up with a formula that works for all of the following entries.
How would you standardize this? There are no seconds when there are hours. the minutes go from left to right depending on if there are hours. If there are 1-9 units it is a single digit rather than always having 2, so it moves the hour, minute or second identifier. Is there an easy way to do this?
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | Idling Time | (The Goal) Idle Time | ||
2 | 5m 8s | 00:05:08 | ||
3 | 5m 11s | 00:05:11 | ||
4 | 14m 33s | 00:14:33 | ||
5 | 1h 2m | 01:02:00 | ||
6 | 10h 5m | 10:05:00 | ||
7 | 12h 15m | 12:15:00 | ||
Sheet1 |
Thanks,