pradeep kumar

pradeep kumar

  • NA
  • 94
  • 67k

Hours Calculation in SQL Server

Feb 22 2014 12:30 PM
I'm doing like this..!!!
DECLARE @minutes AS INT
SET @minutes = 1.80*100
SELECT @minutes / 60 + (@minutes % 60) / 100.0 AS Hours
it gives me 3.000 but the result should be 2.20 hrs
how can i acheive that..?
pls help me out

Answers (2)