Hey all!
Great to be a new member on the forum.
I've got a series of time data (durations) in the following formats:
7m
35m
1 h 6m
1 h 25m
I want it to look like this:
0:07
0:35
1:06
1:25
I figured out a formula using nested if statements but I know there's a simpler way.
My solution counted the number of character, then manipulated the string in different ways depending on the number of characters
E.g. =IF(LEN(A1)=2,"0:0"&LEFT(A1,1),IF(LEN(A1)=3.... etc
It worked but it wasn't pretty.
Who can enlighten me?
Thanks guys!
FoddeR
Bookmarks