Code:
ROUND(convert(decimal(10,1), datediff(minute, shiftstartdate, shiftenddate) / 65.0), 1)
This code right here brings back a 7.8
The value without the round is 7.85
So, if I change the code to convert(decimal(10,2) it brings back 7.90
How do I return a value of just 7.9. shiftstartdate and shiftenddate are datetime values.