Thread: Time Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Time Formula

Pull=down:

Tools Options... Calculation and check the 1904 data system
--
Gary's Student


"DMJohnson" wrote:

I need a formula to calculate differance in set times.
Example: 2:39 and 2:49 (m:sec) The problem is negative times display as
######.
Some solutions will be positive and some negative.