aideb
asked on
Convert to time
I am trying to convert the times from text
e.g.
1m 5s left
4m 30s left
13h 4m left
14h 20m left
14h 35m left
14h 40m left
3d 14h left
There is likely to be a clever way to do this....Can anyone help?
e.g.
1m 5s left
4m 30s left
13h 4m left
14h 20m left
14h 35m left
14h 40m left
3d 14h left
There is likely to be a clever way to do this....Can anyone help?
ASKER
Hi,
I am having some issues with getting this to work. Can you take a look and see whats wrong?
https://docs.google.com/spreadsheets/d/1MwHV93h6Ne0qAXECucq4caqJ7X393Wm5q8vZMSvSrvo/edit?usp=sharing
Thanks
I am having some issues with getting this to work. Can you take a look and see whats wrong?
https://docs.google.com/spreadsheets/d/1MwHV93h6Ne0qAXECucq4caqJ7X393Wm5q8vZMSvSrvo/edit?usp=sharing
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works a treat! Thanks again.
You could use the split Function
=Split(A1, " ") to separate the elements
then
read the characters before the letter and mutiply by the number by the time it represents
=RIGHT(B1,LEN(B1)-1)*(IF(L
and the add all the partial results in one cell
Regards