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.
|