On 2002-05-10 09:43, kaneson wrote:
I have a col of time in the format 2.17 that is 2 min and 17 sec. How this can be convert to 2 17/60 min.
Thank you
On 2002-05-10 10:17, IML wrote:
Thanks. I started down the same road you did, but distingushing between 3.05 and 3.5 got a little messy. I guess something along the lines of
=SUBSTITUTE(REPLACE(TEXT(A1,"0.00"),LEN(TEXT(A1,"0.00"))+1,3,"/60"),"."," ")+0
would cover that.
On 2002-05-10 10:53, kaneson wrote:
Thank you, it work!!!
I work this way.
=TRUNC(E2)+(E2-TRUNC(E2))*100/60
Is there any other options other than this two