Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Smart Indenter and Excel 2013
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Drawing in Excel 7 - Creating drawings from coordinates
- ULS Design Functions 2.13
Recent Comments
Tag Archives: time rounding
Working with milliseconds in Excel
A recent post at Eng-Tips looked for a solution to problems with working with times in Excel, when time differences are required to the nearest millisecond. The problem is that although times may be entered as a time/date value, and formatted … Continue reading
Posted in Computing - general, Excel, UDFs, VBA
Tagged Excel, milliseconds, msTime function, time format, time rounding, UDF, VBA
1 Comment