Sum of Time and Avg of Time

[siouxprincess]

This is for a report.

I have a module that converts 1h 2m into 1:02:00. I'm trying to sum the time for a group, Production.
=ConvertMinutes(Sum([sys_eusername]='Production')) However, it is giving me a negative time return.

And Access does not seem to like if I try =ConvertMinutes(Sum([sys_request_24mins]IIF([sys_eusername]='Production')))

I also want to do the average time of "Production" as well.

Any suggestions would be appreciated. Thanks in advance.

 

[RuralGuy]

See if these links help a little:

http://support.microsoft.com/default.aspx/kb/q130514/
http://support.microsoft.com/default.aspx?scid=kb;en-us;210604
http://support.microsoft.com/kb/q88657/

 

[siouxprincess]

Thanks for trying to help RuralGuy. I figured out the statement I needed:
=ConvertMinutes(Avg(IIf([sys_eusername]='Production',[sys_request_24mins])))

If I want to get a sum, all I needed to do is change "avg" to "sum".

 

[RuralGuy]

Glad you got it sorted.