Adding Time help

[Bozilla]

I am creating a database that will be used to calculate the time spent with a tutor and then will be used to both pay the tutor and bill the student.

My question is: Is there an expression that I can build into a form that will calculate the start time/end time and come up with a total time?



for example: Start time: 3:30 End Time: 4:00 = Total time: 30 mins

So far I am not having any success with this problem. Please help!

[boblarson]

1. store the date along with the time.

2. Then you can use the DateDiff function to get the number of minutes and you can then convert to hours/minutes as needed.

[Don Webb]

Bob, Don't know about Bozilla but I want to thank you for that info. I had put a project on hold for three months trying to figure the time in hours. This site has helped me more than all the articles and books I have read.

[Bozilla]

Thanks so much for the feedback, I'll give that a try right away.