Thread: Time Function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Time Function

=TIME(0,36,48)-TIME(0,33,5)
and format as [mm]:ss
--
Gary''s Student - gsnu2007d


"Tango" wrote:

I just finished a 5k run that took me 36:48 minutes to complete. Last
year it took me 33:05. I can't find the function to subtract minutes.
I found teh format [mm]:ss and tried all sorts of variations without
luck.

Thanks in advance.
Tango