Hello Everyone,

(this is a repost, the first time I sent it in€¦it didnt post??)
I have a question about an earlier post in the worksheet functions group
from 12/09/04. There was a question about converting numbers to time without
putting in the colons. The answer was a referral to Chip Pearsons site. He
posted some code that converts any 4 numbers to time ie. 1234 to 12:34.
I want to know if it will work if I name a range due to the fact that my
cells are kind of scattered over the sheet and there are a lot of them. For
example this:

A5:A14,B5:B14,E5:E14,F5:F14 (many more than this)

I also want to know how I can make it work for the 6 digit format ie. 123456
to 12:34:56. Thanks for your help.

Rob