Forum Discussion
Hours/Mins X(Rate) wont add up correct
I have setup a sheet for me to add hours/mintues worked in excel. That part seems fine. The hours/Mins add up to: (I10)19:20 The Hourly Rate is: (G11) £12.17 For the total sum: (I12) £235.29 ...
19:20 is not 19.33 hours but 19.33333333333... hours.
19.333333333333 * 12.17 =235.2866666666, which becomes 235,29 when rounded to 2 decimal places.
Aghh Makes sense. Thank you! HansVogelaar