On Sat, 30 Sep 2006 20:14:59 GMT, Paul Wagstaff wrote:

Hi All

I have an aggregate query that groups by each user, then calculates

Sum(TimeInvested). I need to display the total time (per user) in hrs / mins

e.g. 45:30 (= 45 hrs 30 mins).

Can someone help me with the function to so this?

thanks

paul

Sum the [TimeInvested] as minutes, i.e. 2 hours 25 minutes = 145

minutes.

Then divide [TimeInvested] by 60 for hours.

i.e. [TotalInMinutes])\60 = 145\60 = 2

(note the backward slash to return an integer value for hours.)

Then use [TotalInMinutes]) Mod 60

to get the remaining minutes.

145 Mod 60 = 25

You may need more than one query to do this.

--

Fred

Please respond only to this newsgroup.

I do not reply to personal e-mail