Hi - Dave here.

Happy Friday!

How do you work with time in hundredths of a second in Excel?

For example, the race results in the worksheet below.

This article offers tips to keep you from going crazy :)

Race times in hundredths of a second

[Download the workbook and read the full article]

The solution starts with applying the right number format. However, there are several quirks in Excel that you should be aware of when working with decimal seconds. The article above provides tips, formulas, and the workbook.

Excel formulas

We maintain a list of over 500 working formulas here.

If you need more structure, we also offer video training.

Have a great weekend!

Dave

 

Exceljet Logo
Exceljet
P.O. Box 4804
Salt Lake City, UT 84110

Copyright © 2024 Exceljet, All rights reserved.
You received this email because you are subscribed to our newsletter.
To unsubscribe, click the link below.