The Sum Of Time

mtagliaferri

Registered User.
Local time
Today, 08:46
Joined
Jul 16, 2006
Messages
550
I have been looking in the forum but could not find what I need, that should be really simple!!!! I have a table that contains working hours per day, I then have a formwith a list of times (in a 24h format) I need the total of the hours as following:
05.15
03.18
07.43
12.24

The total I have to see in the textbox calle SumTime is 28.40

What formula should I putin the text box?
 
I would look into cross-tab queries, that is a good way to monitor a total on running values.

Once you get a query that will search for the right record, and give you the total hours, simply create your form to include your table and your query. Use the controls you need to edit data on your table, and then us the query result as your running total on your form. If done this way you may not even need a cross-tab query to do it, simply a query that searches for the record, and add a field which is the sum of the hours worked.

This all assumes that you DO have it working where when you enter the two times the time on that job DOES calculate correctly. For example, when you enter 8:00 and 10:00 the table automatically enters 2 or 2.0 for the hours worked on that specific job. If that works, running a sum of those hours worked should be easy. It might even be easier to make that field a number field rather than a date/time field, as it only shows the difference, and you want your results in a format with a decimel (8.4 total hours worked) rather than time/date format (8:40 worked).

Hope this helps!

If this doesnt work for you, attach your DB or take a screenshot of your table, with data in it, and I will look at it and try to get an idea of what you need.
 
Last edited:
mtagliaferri........
This is a DB of mine that has gone thru alot of changes since this older version....... But I think you can see the formulas you need.
 

Attachments

Thanks Curtis, this seems what I need, I will have a proper look and let you know if I need further help!!
Marco
 

Users who are viewing this thread

Back
Top Bottom