Hi RonMcK,

I enter times in selected cells. And the range can shrink or grow. It depends on the amount of testing I am doing. The times has to be entered down to the second.

I was thinking a macro that could be created when ONLY a number is found in a cell. The colon ( : ) will be entered between the digits starting from the right, move 2 characters left, enter colon, move 2 characters left, enter colon.

OR.... just a way to format the cell to accept 5 - 6 digits ( for times that are 1:12:50 or 12:13:59) and enter the colons in the appropriate locations.

Thanks for you help,
Dave