Forum Discussion

robertdh31's avatar
robertdh31
Copper Contributor
Nov 17, 2023

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

 

The total sum is: =SUM(I10*24)*G11

 

For this period i am out by around 4p?

19.33 x 12.17 = 235.2461 so £235.25

 

Any ideas where I am going wrong?

 

Rob.

Resources