user8100689
Reputation:
Convert Geographic Time Format to HH:MM:SS
Hello I am fairly new to VBA,
I have this specific time format looking like this:
1H 23’ 45,67”
Which translates to 01:23:45 as in HH:MM:SS
I am unsure if I could convert my range K2:K90
How would I approach this?
Upvotes: 1
Views: 56
Answers (1)
user4039065
Reputation:
try,
=TIMEVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, "H ", ":"), "' ", ":"), ",", "."),UNICHAR(8217)&CHAR(32), ":"), UNICHAR(8221), TEXT(,)), CHAR(34), TEXT(,)))
Format the cell as [hh]:mm:ss or [hh]:mm:ss.000 as you like.
Upvotes: 2
Related Questions
- Time difference to hh/mm/ss conversion
- How can I convert time (time zone)
- Convert date/time in certain format with VBA
- Formatting time from dd/mm/yyyy hh:mm:ss to yyyy.mm.dd hh:mm
- Excel VBA Converting seconds to HH:MM:SS
- Converting hh:mm:ss to text using VBA for Excel
- VBA decimal > 1.0 to time hh:mm:ss format
- How do I convert a given number into time format HH:MM:SS in VBA?
- How can I separate time from time zone and put time in format "yyyy-m hh:mm:ss"?
- Creating VBA function that converts minutes to hh:mm:ss