I have an excel timesheet that creates a total hour calculation after a range of in and out times are entered (cell format [h].mm). This works fine with one exception - the number of minutes are actually "minutes" and not decimal. For example - 7.5 hours shows as 7.30 when I had hoped that it would show as 7.5. I am sure that my cell formatting is the problem. I am not sure how to get the cell to see 60 minutes as %100 and 30 minutes as %50 on and on. Can anyone help a rookie?