"Brian" <[email protected]> wrote in message
news:[email protected]...
> in column F and about 700+ cells down, are times that where entered like
> this...
> 010754. But the times were meant to be entered as such... 01:07:54. The
> colons are missing. Is there a quick and easy way to somehow enter the
> colons in all the times, without having to do it manually for each time?

=TIME(LEFT(F1,LEN(F1)-4),MID(F1,LEN(F1-3),2),RIGHT(F1,2))

This could be simplified slightly if the number in column F has preserved
its leading zero, but the formula above copes with cases where it hasn't.
--
David Biddulph
Rowing web pages at
http://www.biddulph.org.uk/