Hi Experts,
I seek your help for ideas on the below requirement in Overtime Calculation.
Requirement:
Overtime hours are calculated from difference in Working hours and scheduled hours. Now, the client needs to display the overtime hours only in hours and if there are minutes then it should be neglected.
For example,
Employee Planned working time: 09:00 - 17:00 (for simplicity consider no break).
Employee Recorded working time: 09:00 - 18:15
Overtime: 1 Hour and 15 minutes, in this case the time account should hold 1 hour whereas the minutes should be left out.
The difficulty which I am facing is how to get the multiple of hours separated from minutes. i.e,. 2 hours 48 minutes then I have to filter out 2 hours alone and rest of the minutes need to be ignored.
With Regards,
GM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.