formatting time in excel

J

JE McGimpsey

Format won't affect whether XL accepts an input (it will accept times to
the thousandth of a second, e.g., 1:23.456).

You can display times to the hundredth using Format/Cells/Number/Custom

m:ss.00
 
Top