Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

When calculating time intervals in Excel, you are looking for the time that has passed between two given sets of time. Because Excel converts dates and times into numbers behind the scenes ...