Thank you very much for your response. I should have mention that I am beginner with access and I that have never written code before. If you could tell me were to enter the code I should be able to figure it out from there.
Thank you,
Stephen Jones
I am trying to calculate the total amount of time in hours that it takes to complete a test. I had two fields in my table called:
StartTime
EndTime
I than used the following formula to calculate the total time:
=Format([StartTime] -1 -[EndTime]’ “ShortTime”)
This formula works find. But...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.