Adding up time past 24 hours

[mkelly]

I have a database that tracks time worked on a project and the weighted average of that project. I need to take extended periods of time and calculate it out past 24 hours.

I am usint ([time finished]-[time started]) in my query to get total time worked however I do not know how to add all the "total time worked" records together to get a number of say

soandso worked 105 hours last month and completed 5679 weighted pages.

So that I can come up with and average page per hour count..

Does anyone know how to add up the time?? it is enetered into the table as now()

 

[crosmill]

Break your hours into minutes divide by the number of completed pages = average time per page (in minutes)

TimeTaken = (TotalHours*60) / CompleatedPages

 

[mkelly]

Thanks, but now I have another question.

If the calculation in my query is bassically a:

now()-now()=total time

How do I convert the numeric value to minutes??

 

[crosmill]

now()-now()=0

always

 

[mkelly]

Ok let me clarify better

Time Finished
3/4/2003 5:52:58 PM -
Start Time
3/4/2003 7:52:46 AM
=
total time
0.416805555556493

This is out of my query.

How can I convert that total time to minutes??

Appriciate all the help

 

[Mile-O]

Multiply it by 60 and then multiply the answer by 24.

 

[crosmill]

Oh I see

use the DateDiff() function, check the help in access to find out exactly what to type but will be something like

DateDiff(StartDate, EndDate, n)

I think n is the correct letter for minutes output?? like I say check the help.

 

[mkelly]

Thanks

Total time: datediff("n",[start time],[finish time])

Gave me the minutes. thanks for the help