View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Comparing Stop Watch Times

Hi,

Am Thu, 10 Nov 2016 17:59:31 +0000 schrieb Curtopia:

=IF(A1=B1;A1-B1;"- "&TEXT(B1-A1;"mm:ss,00"))


I could not get the formula to work but I have determined that even
though a negative delta displays as #######, the cell is holding the
correct delta so when I add all the deltas and average them, it is
accurate. It would be helpful to display the negative like it does the
= or + so if you have any other thoughts, let me know. Thanks again for
taking the time to help.


sorry, the format I wrote is a german format. Try:
=IF(A1=B1;A1-B1;"- "&TEXT(B1-A1;"mm:ss.00"))

Or have a look:
https://1drv.ms/x/s!AqMiGBK2qniT_UyWDLtfoMvGp3Ir


Regards
Claus B.
--
Windows10
Office 2016