11-14-2007 11:41 AM
Hi Everyone,
My requirement is something like this...
Consider an employee is entering his time schedule on an hourly basis, I am fetching these into an internal table but when iam fetching i need to sum all the time and display total time he has worked....
How to sum it...
I tried to sum in select query but its summing only the first part (hours) and not summing the minutes....
Can anyone help me on this......
Regards
Naveen
11-14-2007 11:47 AM
11-14-2007 11:47 AM
11-14-2007 11:48 AM
try to convert hours and minutes into minutes and then sum it minutes, then again convert the minutes into hours and minutes