ExcelBanter - EXCEL - I need to compare times to the hundredth of a second

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

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - EXCEL - I need to compare times to the hundredth of a second (https://www.excelbanter.com/setting-up-configuration-excel/31536-excel-i-need-compare-times-hundredth-second.html)

savery422

EXCEL - I need to compare times to the hundredth of a second

I am a swim coach and I need to use excel 2003 to compare times to the
hundredth of a second. How do I format the time?

Bob Phillips

hh:mm:ss.00

--
HTH

Bob Phillips

"savery422" wrote in message
...
I am a swim coach and I need to use excel 2003 to compare times to the
hundredth of a second. How do I format the time?

All times are GMT +1. The time now is 11:00 PM.