R Rolls May 4, 2004 #1 Two fields on a report contain a date-time stamp recorded by =now(). How to display the elapsed time in hh:mm format in a third control?
Two fields on a report contain a date-time stamp recorded by =now(). How to display the elapsed time in hh:mm format in a third control?
R RobFMS May 4, 2004 #2 This may be a good alternative for you: Use High Resolution Timers http://www.fmsinc.com/free/tips.html#TipsforVisualBasic -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This may be a good alternative for you: Use High Resolution Timers http://www.fmsinc.com/free/tips.html#TipsforVisualBasic -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
J John Vinson May 4, 2004 #3 Two fields on a report contain a date-time stamp recorded by =now(). How to display the elapsed time in hh:mm format in a third control? Click to expand... It depends somewhat on whether the time difference will ever exceed 24 hours. A robust way (that will display 192:30 for a week plus half an hour): DateDiff("h", [starttime], [endtime]) & ":" & Format(DateDiff("n", [starttime], [endtime]) MOD 60, "00") Note that it's "n" for miNutes - "m" is Months in both datediff and Format expressions.
Two fields on a report contain a date-time stamp recorded by =now(). How to display the elapsed time in hh:mm format in a third control? Click to expand... It depends somewhat on whether the time difference will ever exceed 24 hours. A robust way (that will display 192:30 for a week plus half an hour): DateDiff("h", [starttime], [endtime]) & ":" & Format(DateDiff("n", [starttime], [endtime]) MOD 60, "00") Note that it's "n" for miNutes - "m" is Months in both datediff and Format expressions.
