how can I sum stop watch time

[msamir12]

Hi all,
I have an access stopwatch form that records the stop watch result in a table and I want to sum the table results to give me the result per day and then the result per month for all time recorded in this table from the stopwatch .. the time count is in this form 00:00:00:00

Please I need fast responce

 

[svendiamond]

What does your data look like? Help us help you.

 

[msamir12]

What does your data look like? Help us help you.

thnks for respond I will attach the link for my file and you can check it ..

I have an access form works as a stopwatch and when I press the reset button it records the result into a field in a table I want to "sum" the time column to know the sum of the whole time per day from that table .. please check the below link and answer me

file link stopwatch3 - Download - 4shared - Hamza Mostaaf

 

[svendiamond]

Instead of making us download your file, use the HTML Maker add-in for Excel which makes it easy to copy and paste your data into the forum. Here is the link: http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2545970

Put the ".xla" file in your %AppData%\Microsoft\AddIns folder and enable the add-in in Excel.

 

[Micron]

or just copy and paste from Excel if it's not too complex. That will automatically create an HTML table.

 

[msamir12]

thanks guys it is access DB and access form

 

[Micron]

That is your response to a request for data instead of having to download a file? There isn't even a clue as to what version it is.

 

[msamir12]

I work on office 2007 and the table is like that

<tbody>
[TH="bgcolor: #c0c0c0"] ID
[/TH]
[TH="bgcolor: #c0c0c0"] time [/TH]

</tbody>

51	00:00:00:31
53	00:00:00:43
55	00:00:00:00
56	00:00:00:15
58	00:00:04:18
59	00:00:00:18
60	00:00:00:57
63	00:00:10:46

<tbody>
</tbody>

<tbody>
[TH="bgcolor: #c0c0c0"][/TH]

</tbody>

 

[Micron]

I went to the download site and all I can say is, yikes. Video commercials/ads, multiple links with who knows what included in the download...not for me. Would trust Google file sharing, though.
Is your data days:hours:minutes:seconds (dd:hh:nn:ss) or hours:minutes:seconds:milliseconds (hh:nn:ss:fff)? I think the former, but usually a stopwatch function records milliseconds using the GetTickCount in the kernel32 dll library. An elapsed time result would look like 32887116 without formatting or conversion. Perhpas you are storing the data in the table this way, but are formatting it to show in one of the ways I just asked about?

This might be as simple as a Totals query where you sum the time field and group by date using a date (for a single day) or a date range (for a month) as date criteria.

 

[Micron]

just found out this is cross posted 2 other places but not declared in any of them, so I'm done now.