I am creating an employee time sheet that the put in their starting time and
ending time (From a drop down list). I would like Excel to calculate the
amount of time showing full and if need be a half hour. My problem is that
the results half only been in full hours. Such as 9 am to 5 pm comes out as
8 hours. But also 9 am to 4:30 pm also comes out as 7 hours instead of 7.5
hours.

I have tried three types of formulas with the same result:

=TEXT(F11-E11,"h")

=(INT(F10-E10*24))

=hour(f10-E10)

Any ideas on getting the results I need?

Thanks,
Ken