Spreadsheet: 838678d1691248956-mround-and-ceiling-are-not-round-correctly-as-per-system-hols
Sheet: HP (2)

NO | Start  Date | Holiday Entitlment | HR | Pro-rated-Mround | Pro-rated-Ceiling | With out rounding | DIFF-Mround | DIFF-Ceiling | Resut
497 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
498 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
499 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
501 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
503 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
504 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
505 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
506 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
507 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
508 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
509 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
510 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
514 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
515 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
517 | 2023-01-16 00:00:00 | 20 | 19.5 |  |  |  |  |  | Ceiling is correct
525 | 2023-01-09 00:00:00 | 25 | 25 |  |  |  |  |  | Ceiling is correct
529 | 2023-02-10 00:00:00 | 25 | 22.5 |  |  |  |  |  | Ceiling is correct
530 | 2023-02-10 00:00:00 | 25 | 22.5 |  |  |  |  |  | Ceiling is correct
531 | 2023-02-10 00:00:00 | 25 | 22.5 |  |  |  |  |  | Ceiling is correct
532 | 2023-02-10 00:00:00 | 25 | 22.5 |  |  |  |  |  | Ceiling is correct
533 | 2023-02-13 00:00:00 | 25 | 22.5 |  |  |  |  |  | Ceiling is correct
534 | 2023-02-13 00:00:00 | 20 | 18 |  |  |  |  |  | Ceiling is correct
535 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
536 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
537 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
538 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
539 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
540 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
541 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
542 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
543 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
544 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
545 | 2023-02-06 00:00:00 | 20 | 18.5 |  |  |  |  |  | Ceiling is correct
546 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
547 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
548 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
549 | 2023-02-13 00:00:00 | 20 | 18 |  |  |  |  |  | Ceiling is correct
550 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
551 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
552 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
553 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
554 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
555 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Mround is correct
556 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
557 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
558 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
559 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
560 | 2023-02-13 00:00:00 | 20 | 17.5 |  |  |  |  |  | Both Incorrect
561 | 2023-02-13 00:00:00 | 20 | 18 |  |  |  |  |  | Ceiling is correct
562 | 2023-02-17 00:00:00 | 20 | 17 |  |  |  |  |  | Both Incorrect
563 | 2023-02-13 00:00:00 | 20 | 18 |  |  |  |  |  | Ceiling is correct
565 | 2023-02-21 00:00:00 | 25 | 22 |  |  |  |  |  | Ceiling is correct
566 | 2023-02-20 00:00:00 | 25 | 22 |  |  |  |  |  | Ceiling is correct
567 | 2023-02-27 00:00:00 | 25 | 21.5 |  |  |  |  |  | Ceiling is correct
568 | 2023-03-06 00:00:00 | 20 | 16.5 |  |  |  |  |  | Mround is correct
577 | 2023-03-21 00:00:00 | 20 | 16 |  |  |  |  |  | Ceiling is correct