m17347047711116
Registered User.
- Local time
- Today, 19:33
- Joined
- Feb 4, 2002
- Messages
- 68
I have a report for which i calculate the total hours worked in a week and show the total in an unbound box on my report. I do not show the individual daily hours i just make them visible "NO".
The formula in my unbound box currently is as follows:
=Nz([EndTime])-Nz([StartTime])+Nz([EndTime1])-Nz([StartTime1])+Nz([Endtime2])-Nz([StartTime2])+Nz([Endtime3])-Nz([StartTime3])
Now i would like to perform a calculation based on the results of the above formula.
What i would like to do is take the total of all the calculations on my report that show up in the unbound text box and perform and average hours calculation.
Problem is i can't figure how to take the values from the unbound box that show the total weekly hours and have another unbound box that averages the results
The formula in my unbound box currently is as follows:
=Nz([EndTime])-Nz([StartTime])+Nz([EndTime1])-Nz([StartTime1])+Nz([Endtime2])-Nz([StartTime2])+Nz([Endtime3])-Nz([StartTime3])
Now i would like to perform a calculation based on the results of the above formula.
What i would like to do is take the total of all the calculations on my report that show up in the unbound text box and perform and average hours calculation.
Problem is i can't figure how to take the values from the unbound box that show the total weekly hours and have another unbound box that averages the results
