Tag Archive: Time format

Articles sur le thème : Time format

Calculation of tenths, hundredths and thousandths with Excel

3 Thousandths 😱😱😱 Looking at results of speed skating in the Olympic winter games of 2014, the gap between the first and second of the 1500m race was only 3 thousandths. Separate athletes with thousandth is extremely unusual and this give me the idea to calculate what represent 0.003 after 1500m race. With Excel, it’s …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/calculation-tenths-hundredths-thousandths-excel/

Convert Latitude and Longitude

Nowadays, GPS localization is common. Some apps use decimal format (48.85833) while others return the coordinates in degrees, minutes and seconds (48°51’29.99”). In this article I will show you how to convert from one format to the other and vice-versa. Add GPS coordinates to address If you are looking to add GPS coordinates to an address, please …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-latitude-longitude/

How does Excel deal with hours over 24

Excel doesn’t display hours over 24 by default. But, if you change one option in the number format, you can display hours over 24. Difference between hours and days in Excel Rule 1 : A whole number is a day Rule 2 : A decimal number, between 0 and 1, is a time Let’s consider …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/excel-hours-over-24/