I have a timesheet that adds the total hours for a week. For a particular code, an employee worked 32 hours and 15 minutes. In order for me to enter them into our system, I need them in decimal hours, and this case it would be 32.25 hours.

I need a formula to do this automatically. I am using, =IF(R8="","",(R8-INT(R8))*24) which works fine for when there is less than 24 hours, but it won't work in cases like this, and this happens frequently.