Time in Excel
 

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

Time in Excel
 

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

Time in Excel
 

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

Time in Excel
 

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

Time in Excel
 

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

Time in Excel
 

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

"Gibbyky2" wrote in message
...
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

Time in Excel
 

thanks for that

"David Biddulph" wrote:

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

"Gibbyky2" wrote in message
...
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

Time in Excel
 

I get 0:06:04 since you are adding 17 seconds to 47 seconds?
"Gibbyky2" wrote in message
...
thanks for that

"David Biddulph" wrote:

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

"Gibbyky2" wrote in message
...
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