Time function - elapsed hh:mm

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?

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Rolls" wrote in message
...
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?

On Tue, 4 May 2004 09:21:35 -0500, "Rolls"
wrote:

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?


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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public