Good Morning everyone,
long time member, but have never posted!
I have a problem I just cannot solve, I have a list of data provided to me which falls like the below and is based on time spent using a system:
1h 32m 5s
54m 8s
7h 54m 4s
Is there a way I can use a formula to bring back the characters before "h" which I can change to use it for "m & s" too?
I have been fiddling with the MID and LEFT coupled with FIND but cannot get the result I need.
Using text to columns does not work in this instance as i need all the hours in one column and minutes in another and so on.
I just need a way to quickly separate the results into three columns one for H one for M and one for S??
Bookmarks