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.