Time Conversion [SOLVED]

    Will,


    Since you came up with the last answer so quickly, I hope you don't mind if I trouble you for one more?


    I need a common formula that will convert the following text numbers to time formats:


    1323 converted to 13:23
    642 converted to 06:42


    The problem is that the number being converted, (i.e. 1323, or 643) will be either 4 or 3 digits. So far I have been able to come up with a formula to convert one or the other, but I really need a common formula that, when applied, will convert either of them to the correct time format.


    Again, any help is appreciated. Thanks.

    This formula will reformat your text input, leaving it in text format.



    =IF(LEN(A1)=3,"0","")&LEFT(A1,LEN(A15)-2)&":"&RIGHT(A1,2)

    Thank you both for your input. The solution worked. It was so easy, it could have hit me. The solution was:


    =TEXT(G2,"0\:00")+0


    Thank you again!!!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login