Skip to Content

Hundreths not daily rounding but minutes does


SCENARIO:

7:30 - 12:00p
12:25p - 3:59p

Daily rounding is unit 6 point 5.

If when in minutes view, rounded total is 8:00
When in hundredths view, rounded total is 7.99 - WHY???

ANSWER:

We don’t round the hundredths directly as this is inaccurate. We subtract the minute difference from actual minute total vs. rounded minute total to the hundredths total.

FORMULA:

Total punch pair in minutes, 4:30 for morning + 3:34 for afternoon
Total entire day, 8:04
Difference between actual minute total to rounded total is 4 minutes or 0.07 in hundredths
Total 1st punch and last punch = 8:29 then convert to 100s = 8.48
Convert meal 00:25 to 100s = 0.42
Subtract meal from day total = 8.48 - 0.42 = 8.06, now you have your hundredths total but not yet rounded
To apply rounding to the hundredths...
Subtract the minute difference from when minute total was rounded which was 00:04 but 0.07 in hundredths off of the hundredths daily total of 8.06
Your hundredths/rounded total value is 8.06 - 0.07 = 7.99

Get notified when new articles are added to the knowledge base.

Powered by PHPKB (Knowledge Base Software)