Tag Archive: Time calculation

Articles sur le thème : Time calculation

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 in common usage. Some apps use decimal format (48.85833), others return the coordinates in degrees, minutes and seconds (48°51’29.99”). In this article I will show you how to convert one format to the other and vice-versa. How to write a coordinate in Excel GPS coordinates are generally written using the symbols ° (degrees), ‘ …

Continue reading

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