Changing time entries from minutes to decimal

[bgoodell]

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?

 

[Aladin Akyurek]

=A1*24

where A1 houses a time value in the form 7:30.

Format the formula cell as General.