Thread: Time Function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Time Function

On Feb 24, 5:20*am, 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. *


It would be nice if you explained what went wrong, not simply "without
luck". But let me guess: despite the format [mm]:ss, when you
entered 33:05, you got a large number, namely 1985:00. At least, that
is what happens in Excel 2003. The problem is: apparently, Excel
still requires that you enter the number in the form h:mm:ss.

So, if you enter 00:36:48 in A1 and 00:33:05 in A2, both formatted as
[mm]:ss, then put the following in A3:

=A1-A2

A3 will inherit the format [mm]:ss.