time in minutes and seconds and .00


G

Guest

I don't know how to format a cell so when I enter a number it is not in a
date format. I want the number to be displayed as minutes, seconds, and 2
decimals.

Thanks in advance
Adam
 
Ad

Advertisements

G

Guest

Go to 'Format", Cells
click on the number tab on the top
Scroll down to the ' custom' selection and a dropdown box will apear on the
right.
select mm:ss at the bottom of the box
 
Ad

Advertisements

T

T. Valko

Custom format as [m]:ss.00

Select the cell in question
Goto the menu Format>Cells>Number tab>Custom

In the little box under "Type" enter:

[m]:ss.00

OK out

The [ ]'s keep the minutes from rolling over after 60 into hours.
 

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

Top