Time in Excel

[Gibbyky2]

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

 

[pdberger]

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]

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

 

[Bernard Liengme]

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

 

[Gibbyky2]

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

 

[David Biddulph]

You can display what you like (Format/ Cells), but in inputting the data you
need to let Excel know that you want 0:5:47 and not 5:47:00
Hence Bernard's reply to you.

 

[Gibbyky2]

thanks for that

You can display what you like (Format/ Cells), but in inputting the data you
need to let Excel know that you want 0:5:47 and not 5:47:00
Hence Bernard's reply to you.

 

[Meebers]

I get 0:06:04 since you are adding 17 seconds to 47 seconds?