Ok thanks guys. between all of you i have pieced it together.
SORRY for the caps didnt realise.

1 other problem,
It now turns the number i enter to 00:01:34 which is ok and the cells change
colour but the split time .672 no longer shows is there a way to bring the
full time up as i cant find it on format
Once again thanks

"David Biddulph" wrote:

You have deleted the entire content of the message to which you are
replying, which is presumably the messaghe from Peo. You haven't answered
the part where he told you that you needed to insert the data in the correct
format.
1.33.672 is NOT a time
1:33.672 IS a time.
There is a big difference between a full stop and a colon.
If you start by putting the data in the wrong format, it will be treated as
TEXT, as Peo told you. Trying to change the cell format subsequently will
not help, as the cell contents are still text.

Try again.
--
David Biddulph

"PAULANDBEX24" wrote in message
...
THANKS BUT IT HAS NOT WORKED.

BOTH CELLS ARE FORMATTED IN TIME with 24 hr clock
I inputted your formula but nothing has changed
This seems to be the formula i used in office 2003 but i am now using
office
2007.
Any ideas