topic Working Hours Calculation possible ? in Application Development and Automation Discussions

Working Hours Calculation possible ?

former_member207070 — Thu, 17 Sep 2009 20:53:18 GMT

Anyone know if there is a FM to calculate the Working Hours that exist between two dates.

For instance ...entire year may = 2080 working hours. User wants to know Working hours between

any two dates .... like.... July 1, 2007 and May 5, 2008.....

Thanks

MPersson

Re: Working Hours Calculation possible ?

Former Member — Thu, 17 Sep 2009 21:14:24 GMT

You can find the working days between two dates but unless you want to assume that someone worked for 8 hours for each work day, you cannot find the working hours. Of course, if you implemented HR and time entry in your SAP, then maybe.

Re: Working Hours Calculation possible ?

former_member207070 — Thu, 17 Sep 2009 21:31:27 GMT

Srinivas

Thank you for your response.

I dug around some more and found that I can use

FUNCTION 'HR_99S_INTERVAL_BETWEEN_DATES'

to calculate the number of weeks between dates.

I can then multiple the #of Weeks by 40 hrs.

That ends up working for me.

Thanks again.

MPersson

Re: Working Hours Calculation possible ?

Former Member — Thu, 17 Sep 2009 21:34:53 GMT

And if there are holidays? Or fractions of weeks??

Rob

Edited by: Rob Burbank on Sep 17, 2009 5:36 PM

Re: Working Hours Calculation possible ?

former_member207070 — Fri, 18 Sep 2009 14:02:40 GMT

Rob,

Thats a valid point. In my case I am only determining the total possible working hours for a budget report.

Prior to this, the supervisors were simply using a full year of 52 weeks x 40 hrs = 2080. This report takes

the hours captured on the CATS timesheet and processes them accordingly. So Holidays and any leave

time is identified within the program code and handled then.

Thanks

MPersson

Re: Working Hours Calculation possible ?

Former Member — Fri, 18 Sep 2009 14:08:21 GMT

But FM HR_99S_INTERVAL_BETWEEN_DATES gives the wrong number of weeks for fractions. If you use today's and tomorrow's dates, I think you'll find that it returns zero weeks. Is that what you want?

Try using days and multiply by eight instead.

Rob

Edited by: Rob Burbank on Sep 18, 2009 10:09 AM

Re: Working Hours Calculation possible ?

Former Member — Fri, 18 Sep 2009 14:13:01 GMT

Hi You can find calendar settings in country specfic settings this where you maintain holidays. Look for an FM which takes country or calendar id as input it is easy to calculate Weeks * 40 or Days * 8 for these results. It gets really easy if you HR on same box. You can take teh concept from following and build one yoru own will eb handy for future.

FIMA_DAY_CONVERT_TO_WORKINGDAY

Re: Working Hours Calculation possible ?

former_member207070 — Fri, 18 Sep 2009 18:11:23 GMT

Both of you have provided good solutions.

Looks like I'll have to code some revisions.

Thank you

MPersson