Subtracting one time from another
Posted on 2000-04-07
I am working on my thesis project for University and I am having some trouble with a particular CF task. Any help on this would be greatly appreciated.
Basically what I need to do is record the time that a user has spent on a page. The way I am approaching this is when the user enters the page I have CF record the current time in Microsoft Access, in a field called “TimeIn” and when they exit the page they go to a new page that records the time in another field called “TimeOut”
Then when I output the data, I would like to subtract the TimeIn from the TimeOut and display the Duration as a separate number.
I am not sure on the best way to achieve this, I have tried many ways but I cannot get it to work.
I would like the desired output to look like this
Time In: 16:24:15
Time Out: 16:25:20
Some other questions pertaining to this problem are:
How should I store the time in the Access database? Should I apply time formatting/mask to the date first or should I do this only when I output the data?
What should I set the Datatype in Access to? Should I set it to Date/Time or as a Text ?
Thank you for any help on this and if someone knows of a better way to achieve this result please let me know how to do it.