How can I format an cell in excell:10min50Sec 88hundreths of a Sec

A

Alfred Nobel

I would like to write 10:50:88 so that Excel understands that I mean
10 minutes 50 Seconds and 88 of a second: mm:ss + what? Do you know how to
format?
 
N

Niek Otten

Format as mm:ss.00 and enter 10:55.88 (note the period instead of colon)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
A

Alfred Nobel

Thanks a lot Niek Otten, that did the trick!

Niek Otten said:
Format as mm:ss.00 and enter 10:55.88 (note the period instead of colon)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Top