Thread: Excel Help
View Single Post
  #5  
Old 13th August 2006, 12:41 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

Quote:
Originally Posted by Benny
I using the following formula to compare times, but there is an error. Can someone please help?

=(1:38.06-1:42.45)/0.066)


benny


Try:

=("1:42.45"-"1:38.06")/0.066

You may need to change the cell format.

I don't know what you're trying to do.

Get ~16 times ~4.4 Seconds?

----

Nor do I understand Wunflova's point.
Reply With Quote