If it is showing as 00:01:34 you have presumably got it formatted as
hh:mm:ss. Peo told you to format the cell as format the cell as mm:ss.000
[you can do that in Format/ Cells/ Number/ Custom].

If you are struggling with the basics, you probably need to read one of the
books such as Excel for Dummies, or do some of the many basic Excel courses,
either using on-line tutorials (such as those at
http://office.microsoft.com/en-us/tr...831141033.aspx) or
elsewhere. You can answers to most things in Excel help.
--
David Biddulph

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