ExcelBanter - formatting cells for time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formatting cells for time (https://www.excelbanter.com/excel-discussion-misc-queries/151414-formatting-cells-time.html)

Terrie

formatting cells for time

I need to format cells to enter time in minutes, seconds and hundredths of
seconds. eg 2:45:89 (2 mins, 45 seconds and 89/100) How do I do it?

Stefi

formatting cells for time

Custom format:
mm:ss.00

Regards,
Stefi

€žTerrie€ ezt Ã*rta:

I need to format cells to enter time in minutes, seconds and hundredths of
seconds. eg 2:45:89 (2 mins, 45 seconds and 89/100) How do I do it?

All times are GMT +1. The time now is 02:08 PM.