Entering in Minutes and Seconds
 

Hi all

I have formatted the cell from the Custom in cells to MM:SS. But it does not
appear to be the correct way as the results are not correct when I enter them

Hope you can help

Stew

Entering in Minutes and Seconds
 

Suppose you want to put 45:00 in the cell - you need to enter it
EITHER as 0:45:00 OR as 45:00.0 (i.e. with a leading 0: to indicate
zero hours, or with a trailing .0 to indicate zero fractions of a
second).

If you just enter 45:00 then Excel will assume this means 45:00:00,
which is not what you want.

Hope this helps.

Pete

On Jan 9, 4:44*pm, stew wrote:
Hi all

I have formatted the cell from the Custom in cells to MM:SS. But it does not
appear to be the correct way as the results are not correct when I enter them

Hope you can help

Stew

Entering in Minutes and Seconds
 

Thanks Pete

Stew

"Pete_UK" wrote:

Suppose you want to put 45:00 in the cell - you need to enter it
EITHER as 0:45:00 OR as 45:00.0 (i.e. with a leading 0: to indicate
zero hours, or with a trailing .0 to indicate zero fractions of a
second).

If you just enter 45:00 then Excel will assume this means 45:00:00,
which is not what you want.

Hope this helps.

Pete

On Jan 9, 4:44 pm, stew wrote:
Hi all

I have formatted the cell from the Custom in cells to MM:SS. But it does not
appear to be the correct way as the results are not correct when I enter them

Hope you can help

Stew

Entering in Minutes and Seconds
 

You're welcome, Stew.

Pete

On Jan 9, 5:38*pm, stew wrote:
Thanks Pete

Stew