Excel formula - hours as a fractional result between two time?

Question

I'm looking for an Excel formula that will calculate hours as a FRACTIONAL result, rather than whole hours or as hours and minutes. For example, I need the result between 12:00 PM and 2:15 PM to be expressed as 2.25 hours rather than 2:15 (two hours and 15 minutes). This is for a timesheet template for work.

Answer 1

Say you have 2:15 in cell A1 and 12:00 in cell A2.  Then your formula should be:

(A1-A2)*24