Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Downloads
- About Newton Excel Bach
- Writing Arrays to the worksheet - VBA function
- RCInteract and RC Design Functions 7.03
- Linking Excel to C
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Tag Archives: Text function
Time in hours and minutes between two dates
Dates and times in Excel are stored as a date number, which is the number of days since 1 January 1900, with the value after the decimal point representing the time of day. To calculate the number of hours between … Continue reading
Posted in Excel
Tagged Excel, format times, greater than 24 hours, Text function, time difference
7 Comments