Timestampdiff rounding on hours get to 2 decimal places
672764Nov 27 2008 — edited Aug 7 2013Hi,
I am trying to get round problem of the timestamp diff field giving incorrect rounding on hours.
I used time stamp diff minutes and want to take total minutes and divide by 60, to get hours, so 70 mins would be 1.16' hours. Answers always rounds up, so this would become 2 hours. Is there a way of getting results to 2 decimal places.