Time Function

  • Thread starter Thread starter Tango
  • Start date Start date
T

Tango

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
 
Saying "... without luck" isn't the clearest problem description to help us
in solving your problem.
Perhaps you could tell us what values you have in the cells, what formula
you've used, and what value you got (and what value you expected)?

Possible areas where you may have been confused are:
a in ensuring that you've got numbers that represent mm:ss and not hh:mm.
Try typing in 36:48.0 or 0:36:48, not 36:48.
b in dealing with negative times, which you may be able to display by
using 1904 date system, but beware of possible difficulties switching to and
fro between 1900 and 1904 systems.
 
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.  
Click to expand...

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