Tag Archive: Time format

Articles sur le thème : Time format

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/

Excel 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/