"Brian" wrote in message
...
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/