I have built a database in Access 97 for inputting dates and times. When I have created a report to display the data, I cannot get the times to add up. I have a form with a field for inputting minutes and a field to total all of the minutes spent. I want a grand total. I have tried a running sum but when the sum gets to 24 hours it starts again as a new day. Any ideas from anyone would be much appreciated.
Calculating Times
- Thread starter ewameg
- Start date
RichO
Registered Yoozer
- Local time
- Today, 00:47
- Joined
- Jan 14, 2004
- Messages
- 1,036
Maybe I don't follow exactly what you are saying but is this correct...
Once the total minutes exceeds 24 hours worth it starts back at 0? So 25 hours and 10 minutes would show up as 1 hour and 10 minutes? Do you input the data strictly in minutes, or hours as well? Is it 67 minutes or 1 hour 7 minutes? etc...
I would think you would want to write a VBA event to handle the addition of the minutes. I did this for a form that I use to calculate the total minutes for tracks on a CD.
Let me know, I'll see if I can help you.
Once the total minutes exceeds 24 hours worth it starts back at 0? So 25 hours and 10 minutes would show up as 1 hour and 10 minutes? Do you input the data strictly in minutes, or hours as well? Is it 67 minutes or 1 hour 7 minutes? etc...
I would think you would want to write a VBA event to handle the addition of the minutes. I did this for a form that I use to calculate the total minutes for tracks on a CD.
Let me know, I'll see if I can help you.