Time Fotrmats for cells in Excel

D

doug

I need to format cells to show elapsed time as minutes,
seconds, and hundredths of a second. I.e. 02:04.58 (two
minutes, four point five eight seconds.)

Can anyone help.

Thanks

Doug
 
A

Andy Brown

Doug,

Via Format -- Cells -- Number, create a custom type of mm:ss.00

Rgds,
Andy
 

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