How to format time as hours: %of hours

[peterv6]

Excel 2007
I'm trying to create a timesheet. I want to display the elapsed time as hours: % of hours, in other words, 6:30 should be 6.5 hours.

Cells are B2 - sign in time format time - 1:30pm
C2 - sign out time format time - 1:30pm
D2 - elapsed time format time - 13:30

C2-B2 = D2

example:

9:00 - 2:30 = 6:30

What I want is:

9:00 - 2:30 = 6:5

I think this should be a really simple format change, but I've been trying things for quite a while and haven't been able to come up with the correct formatting. Can anyone please help me out?

 

[mikerickson]

If you want D2 to show as decimal hours. Try using the formula =24*(C2-B2), with the cell formatted as General.