# 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.

• Try this

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

2rrs

• 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!