Entering in Minutes and Seconds

  • Thread starter Thread starter stew
  • Start date Start date
S

stew

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
 
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
 
Thanks Pete

Stew

Pete_UK said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate average given minutes and seconds 4
entering timecode into cells 2
stopwatch times 7
Formating seconds into mm:ss 4
Formula Bar - display of content 4
cells with hours, minutes, and seconds 4
How do I convert time as text 'mm:ss to time value in Excel 5
Converting to minutes and seconds 5

Back
Top