Adding Time

[jotaylor]

I have read most of the messages about time. I can subtract beginning and ending time and get correct results but when I add the results and they are more than 24 hours, it does not show correctly. I have read the two articles from Microsoft and cannot get them working. I need to say I am not a true programmer and not sure how to use the information. Any help would be appreciated.

 

[Jack Cowley]

I don't know what article(s) you are referring to and if you are trying to add a series of times or what. The best I can do is offer you this article which maybe what you are having trouble with. An explanation of what you are trying to do and what you have tried will help us to better understand what you want.

http://support.microsoft.com/support/kb/articles/Q88/6/57.ASP?LN=EN-US&SD=gn&FR=0&qry=q88657&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

 

[jotaylor]

I need to add the differences calculated on a daily basis from the time they enter until the time they leave for each student. Then I need to add they daily totals to get a monthly total hour calculation for each student. It normally will be more than 24 hours and this seems to be the problem. I can get the daily total time just fine but when I do a report and try to add the total for the month it does not display correctly.

I had looked at the article you mentioned and if I understand it correctly, I put the information from the article in a module as an option explicit but nothing changes. I may not have the steps correct to put this information into the Access program. If someone can give me step by step instructions where and how to put the information Microsoft recommends into the database, I will try it again.

Please let me know if you need more information.

 

[jotaylor]

I need to keep track of the daily hours of students in a lab. I set the query up so it will subtract the ending time from the beginning time. This works well. Then, I need to keep track of the total of these calculations per month. Unfortunately the sum is often more than 24 hours so it will not display correctly. I am doing this calculation in a report.

I did read the article you suggested and tried to follow what to do with the procedure. I put it in a module and had a header called option explicit. Nothing changed. I am assuming I probably did not do it correctly. If someone could step me through it maybe that would solve my problem. Otherwise, if there is another solution, let me know.

 

[Jack Cowley]

Email me your email address, if you like, and I will send you an Access2000 demo based on the article I suggest to you.