Hours and Minutes Total [message #554867] |
Fri, 18 May 2012 02:36 |
snsiddiqui
Messages: 172 Registered: December 2008
|
Senior Member |
|
|
In my attendance system I am calculating overtime on daily basis in hours and minutes fields respectively now I have to sum up these values therefore I applied simple sum function to hours and minutes fields.
Lets suppose hours total is 75 and minutes total is 223.8, after division minutes with 60 result is 3.73 and final result look like this 78.73, which is ceating confusion. Correct result is 79.13.
If anybody has any solution, please update.
|
|
|
|
|
|
|
Re: Hours and Minutes Total [message #557466 is a reply to message #554867] |
Tue, 12 June 2012 23:48 |
|
Dear First you need to separate Hours and decimale figures... Using Trunc Function
nvl(TRUNC(ATTENDANCE_HOURS),0)+ROUND(((ATTENDANCE_HOURS)-TRUNC(ATTENDANCE_HOURS))*60/100,2) TOTAL_DUTY_HOURS
Then you can get total hours and minutes
Abrar
|
|
|