Skip to Content
0
Former Member
Sep 25, 2008 at 05:28 AM

Rounding of attendance hours

59 Views

Hi experts,

In the system, rounding of the attendance hours is done. If a person works for two shifts in a day, the rounding is done individually. But the requirement is the rounding is to be done after taking the total of these attendance hours.

For example attendance hr in first shift is 8.20 (rounded to 8)

Attendace hr in second shift is 6.15 (rounded to 6)

Total is 14 hours

But the requirement is 8.20 + 6.16 = 14.36 (rounded to 15)

Because the range 0.25 to 1 will be rounded to 1.

How can I achieve this in table TIP in Time eval? Please advise.

Thanks