Need help writing a query to sum Minutes

[JVZ]

Hello all,

I need help writing a query that will sum the Minutes.

For format of the time field is: MMMMSST (the field will always contain 7 characters).

Where M = min, S = Sec, and T = tenth of a sec.

Any suggestion?

Thanks

 

[JohnDTampaBay]

Is this what you're looking for?

SELECT Sum(Left(TimeField,4)) FROM TimeTable

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[JVZ]

Thanks for the reply. That is sort of what I'm looking for, however I need to also account for the seconds when summing.

 

[jby1]

Try this ...

SELECT 
  Sum(convert(int,Left(TimeField,4))) 
  + (Sum(convert(int,(Substring(Timefield, 5, 2)))) / 60) 
  + (Sum(convert(int,(Right(TimeField, 1)))) / 600) 
FROM TimeTable