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

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?

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Alfred Nobel" <Alfred wrote in message
...
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?

Thanks a lot Niek Otten, that did the trick!

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Alfred Nobel" <Alfred wrote in message
...
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?