i only require mm:ss unless total is over 59 mins

"Bernard Liengme" wrote:

A1= 0:5:47
B1= 0:0:17
C1= A1+B1 and displays 0:5:54
What do you get that is wrong?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Gibbyky2" wrote in message
...
what i am trying to do is the following

A1 is 5mins 17s B1 is 37sec C1 is A1 + B1
A2 is 6mins 10s B2 is 4mins 57s C2 is A2 + B2

A50 is C1 + C2 etc


"pdberger" wrote:

You need to describe your problem in more detail. It may help to know
that
Excel may display time as hh:mm:ss, but stores it as a decimal starting
with
0.000 as 12 midnight, and 0.5 as noon. So Excel, in date/time formats,
Excel
considers the number 1.5 to be Jan 1, 1900 12:00 PM. 2.25 would be Jan
2,
1900 6:00 AM. and so on.

Hope that points you in the right direction.

"Gibbyky2" wrote:

I am working on a template for stats, when i enter time in mm:ss it
shows and
calculates incorrectly. can anyone help in solving this problem

thanks