convert mints into hours

[Member 10562086]

Quote:

select distinct(Emp_Status),
count ( Att_Mints/60) as OTHOUR,
COUNT (Att_Totalmints /60 ) as ProductionHours
from Attendence
inner join EmployeeMaster on fk_Att_EmpCode=fk_Att_EmpCode
where year(Att_Date)='2014' and Month (Att_Date)='1'
group by Emp_Status

in above query Count of

Att_Mints

is =150 and count of

Att_Totalmints

is 120 i want output of OTHOURS=1:30min and

ProductionHours

=2 hour please help me

[Lost User]

You already posted this question at how to store "count of minute' into hours[^]. Please post in one forum only.

Veni, vidi, abiit domum