I have a integer field in minutes that I need to convert to hours and then sum the field I have tried the following code:
left(convert(time,DATEADD(minute,pe.appt_length,0)),5) as APPT_LENGTH_HRS,
this will convert the field to hours but it won't sum when the field is grouped. I have two appointments that are 30 minutes long so the total should be an hour. The apt_length_hrs field isn't summing. I get an error when I try to put a sum in the code.