I need to be able to add the hours while rounding them intra-time period according to the time periods in table 1. So the total of the entire list of hours from table 2 will be 18 instead of 16.75.
(4.50+4.25=8.75 rounds to 9.0)
(1.0+1.5=2.5 rounds to 3.0)
(1.25+1.0=2.25 rounds to 2.0)
(1.75+1.75=3.50 rounds to 4.0)
I'm hoping to be able to do this on the fly rather than storing any additional information. Any ideas???