Time in Excel

  • Thread starter Thread starter Gibbyky2
  • Start date Start date
G

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
 
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.
 
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
 
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
 
thanks for that

David Biddulph said:
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.
Click to expand...
 
Back
Top