Sum overall elasped time from query then report

[davb]

Trying to sum the overall elasped time in hours using "start" and
"end" times in separate fields from multiple rows. I have tried
datediff, timediff and datepart functions on this attemp.

When converting the results in minutes I can easily sum (overall) the
results like so; DatePart("h",[Elasped])*60+DatePart("n",[Elasped]).
But I can not do in hours like; DatePart("h",[Elasped]) & ":" &
DatePart("n",[Elasped]) to sum (overall) in hours.

Secondly how can I sort using months?

Please advise..with examples

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You can sort months like this in a query (SQL view)

SELECT ...
.... etc. ...
ORDER BY Month(DateField)

This will sort by the month number.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7CZeYechKqOuFEgEQJqaACfQZEBJG4cQzY2Iltp1GeVD1 OrfBIAn3Tc
23s63V+L+dSoIGPizr1hMkc2
=I35s
-----END PGP SIGNATURE-----
davb wrote:

Trying to sum the overall elasped time in hours using "start" and
"end" times in separate fields from multiple rows. I have tried
datediff, timediff and datepart functions on this attemp.

When converting the results in minutes I can easily sum (overall) the
results like so; DatePart("h",[Elasped])*60+DatePart("n",[Elasped]).
But I can not do in hours like; DatePart("h",[Elasped]) & ":" &
DatePart("n",[Elasped]) to sum (overall) in hours.

Secondly how can I sort using months?

Please advise..with examples