I need a formula that will calculate the total time in Whole Hours & Percent of Hour.

It also needs to calculate over Midnight - 20:00 hrs to 01:30 hrs which should equal 5.5 hrs total time.

I have read through some similar issues but cannot find anything to covers the over midnight part.

I am using Office 2008 for MAC.

Thanks in advance.